Maverick27
Active Member
- Joined
- Sep 23, 2010
- Messages
- 336
- Office Version
- 2013
- Platform
- Windows
Hi
Anyone care to share a Macro code to copy & paste the data from Cells C & D to Cells A & B ?
Final output:
Below is the criteria rules for formulating the Macro Code:
1. Copy the Data from Cell C & Cell D below the Cell containing the Text "Invoice" on Col D
2. Paste the data on Cell A & Cell B on the 1st instance data of Col C eg: A7/ B7 & A16/B16...etc
3. The Final Row at the bottom of the Sheet is on A6060 & B6060
Final Row Screenshot
Thanks in Advance
Anyone care to share a Macro code to copy & paste the data from Cells C & D to Cells A & B ?
Final output:
Below is the criteria rules for formulating the Macro Code:
1. Copy the Data from Cell C & Cell D below the Cell containing the Text "Invoice" on Col D
2. Paste the data on Cell A & Cell B on the 1st instance data of Col C eg: A7/ B7 & A16/B16...etc
3. The Final Row at the bottom of the Sheet is on A6060 & B6060
Final Row Screenshot
Thanks in Advance