Hi all I have been struggling to generate a macro for the following situation :
There is a master excel with a list of more than 1000 product names under column A (the list is fixed). The corresponding "Sales" are in column B, "Cost 1" in column C, "Cost 5" in column D, for example. These info have to be extracted from another excel, which will be generated on a daily basis.
However, the daily excel might not contain data on all products. Say the daily excel generated ytd contains data on only 10 products, while tdy's daily excel could have data on 50 products. I will need to get the master excel filled, eventually, for data on all 1000 products. Info. For some products, data may appear on daily excels for more than 1 days, I will only need to retain the most recent data on the master excel.
Also the daily excel contains more info which I don't need to retain in the master excel. The info I need are contained in different sheets in the daily excel.
I have been trying to write a macro with vlookup on this, but I can't make the extraction right.
Attachted the sample files, the master excel (for the actual one I have more than 1000 products) and daily generated excel.
Please help anyone? Thanks.
There is a master excel with a list of more than 1000 product names under column A (the list is fixed). The corresponding "Sales" are in column B, "Cost 1" in column C, "Cost 5" in column D, for example. These info have to be extracted from another excel, which will be generated on a daily basis.
However, the daily excel might not contain data on all products. Say the daily excel generated ytd contains data on only 10 products, while tdy's daily excel could have data on 50 products. I will need to get the master excel filled, eventually, for data on all 1000 products. Info. For some products, data may appear on daily excels for more than 1 days, I will only need to retain the most recent data on the master excel.
Also the daily excel contains more info which I don't need to retain in the master excel. The info I need are contained in different sheets in the daily excel.
I have been trying to write a macro with vlookup on this, but I can't make the extraction right.
Attachted the sample files, the master excel (for the actual one I have more than 1000 products) and daily generated excel.
Please help anyone? Thanks.
