Quote:
Originally Posted by shanemarkley
this would be more ideal if it could all be run via Excel if that is not too difficult. I am concerned with not only the fields that have special prices, but all of the fields that are in our inventory.
...
maybe it would be best if the macro just pulled out the needed data based on what liquors an establishment sells and outputted that in the correct format instead of everything?
|
Before proceeding, it would appear that the only data that can reliably be used to match the workbook to the source data are the LCB#s. But that's OK, because it also just happens to be the case that even where the line-wrapping has messed up the data, both the LCB# and the price(s) are on the same line. I take it you want the
retail prices updated. However, where there are two prices, which do you want?