rocketpower2022
New Member
- Joined
- May 11, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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!!
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 |
