That link refers to post 100. From what I see post 100 completes the task of deleting the rows with stores I do not need and also adding a 9 in front of the credit identification number. I dont know much about the code but I dont see anything that might help with the replace module, does that also have within it restrictions about using the replace module? They are ran at different times and it can not be combined if so.
What I am asking now is a task that is completed from within a xlsm file I use for converting. That is used after I fix the credit number and delete stores I do not need.
I attached a xlsm file that is filled with raw data. I then use the "runall" macro to do all the conversions. During this time is when it is searching within the wrong columns. I need to restrict where it looks when doing the replacing.
In column B is the invoice numbers. Column D is the products. I have one product with the name of "85". So if the invoice number has a 85 within it is changing that also. Needs to only do product replacements in column D and only do store replacements in column C
Reply With Quote