Hi, guys,
I have a lot excel files (Client offers) that have the same identical format and products(The products are in same column, but not in sequence). They all have different prices.What I am trying to do is write a macro that goes into each file, looking for exact product price and copy them in to new column near product (something like Vlookup function). (My master file file have all product data base) And I would like give columns file name where data comes from? if it's possible ? Thanks a lot for your help searched a lot but didn't find correct answer or similar example...
I have a lot excel files (Client offers) that have the same identical format and products(The products are in same column, but not in sequence). They all have different prices.What I am trying to do is write a macro that goes into each file, looking for exact product price and copy them in to new column near product (something like Vlookup function). (My master file file have all product data base) And I would like give columns file name where data comes from? if it's possible ? Thanks a lot for your help searched a lot but didn't find correct answer or similar example...
