What I want: A tool / formula to amalgamate my supplier price lists into one price list on a regular basis. The problem: The databases from the the suppliers have overlapping products, but the products don't share the same SKU's or other matchable strings except for the description. We would like to import these price lists into one list and for the tool to search the list with duplicate stock and take the stock item with the best price. From the little research I have done, you can do this by using macros / VB. Attached a few samples of price lists.
18 pekerja bebas membida secara purata $132 untuk pekerjaan ini
Hi, As you investigated and correctly found, the solution would be a VBA code/macro that merge your supplier prices lists. Let's discuss more details on PMB. Regards, Ramin.
Hi sir, very good day to you . I have gone through your requirement ,, yes by macro it can be achieve . I can do it for you , please award this project thanks