Macropod, thank you for fixing that piece. You are correct in saying that 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.

Not sure if you saw my response to Bob, but 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? This would save a ton of time and processing power since it would only need to be a couple hundred items. In the above message, I attached part of the Cost/Intventory spreadsheet I am working with so you can see an example of the format of spreadsheet I am trying to update.

Many thanks for all your help with this!

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?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]