Hi there - am very new to VBA and am trying to create a macro that copies from one column and pastes it in another, based on the column header title.
In Sheet 1 I have a bunch of dynamic data, in Sheet 2 I have several columns. Those with "New data" headers are directly linked to cells in Sheet 1. And I want to compare Old vs New whenever I refresh data in Sheet 1, so I'd like to create a macro that copies the cells under any column named "New Data" in Sheet 2 and pastes the values directly to the right of it to the column named "Old Data." Any help greatly appreciated here ! Thank you so much!!
|New Data||Old Data||New Data||Old Data||New Data||Old Data|
|Formula 1||Paste Value 1||Formula 5||Paste Value 5||Formula 9||Paste Value 9|
|Formula 2||Paste Value 2|
|Formula 3||Paste Value 3|
|Formula 4||Paste Value 4|