I apologize ahead of time but I am fairly new to VBA so not quite enough experience to figure this out on my own. I have tried quite a few things with VLoopup, Index, If Then, etc. I will try to provide the background as short as possible. Every other week I get a system generated report with let's say 4 columns of data (sheet1 below). I need to merge this sheet that will have both existing data (see sheet2) but also have new data. I want to bring over the corresponding comments from sheet2 to match the existing records. Obviously any new records wouldn't have any comments yet. If I can get this then in the future I plan to also flag new records or if there was a change in color/quantity of an existing record. Any help is greatly appreciated.
Sheet1
Sheet2
Aucun commentaire:
Enregistrer un commentaire