Paul, my apologies for the extended delay. I got caught up playing catch up after the holidays. I hope you had a good holiday and got to enjoy a vacation!



You are correct in saying that the LCB# is the only reliable data to match. The way you have your most recent macro setup should work from what I am trying to accomplishment. I am mainly just concerned with the actual price of the product at that time. If there is a sale it should take that price. If not, i should check to make sure the retail price is in fact accurate. As a small follow up, would it be possible to highlight if there is actually a sales price? I believe this is a simple addition to the script though.

So I have the ProductCatalog.txt file located in the same folder as the .xlsm file I am running the macro from and I get the following error:

"Run-time error '9': Subscript out of range"

Clicking on Debug points to the line: "StrItem = Split(StrData, " ")(0)"

In regard to your Note, the items marked as "SLO" where there LCB# is located is special pricing cases that will have to be ignored as there pricing comes directly from the liquor reps. These will just have to be updated manually. Is there a way that is "SLO" is the LCB# just to skip over that field instead of blanking out the retail price?

As always, thank you very much for your efforts with this. I think we are getting really close to what I am looking for!