L
Legacy 138945
Guest
I’m looking for VBA Code to address the following situation.
I have a table that has an unknown number of rows.
Every 4 rows is another (set of different) record(s).
I need to copy K2 to O2, L3 to O3, M4 to O4 and N5 to O5 into the New Column ‘O’.
That needs to be done until the end of the Table.
Note: these cell contain numeric values with decimals and may be 0.00.
If possible, please code it as simply as possible to allow for easy modifications to change the Range(s).
(Creating the Column ‘O’ in VBA code is optional; I could do it manually, if necessary)
Thank you in advance for you time and effort.
I have a table that has an unknown number of rows.
Every 4 rows is another (set of different) record(s).
I need to copy K2 to O2, L3 to O3, M4 to O4 and N5 to O5 into the New Column ‘O’.
That needs to be done until the end of the Table.
Note: these cell contain numeric values with decimals and may be 0.00.
If possible, please code it as simply as possible to allow for easy modifications to change the Range(s).
(Creating the Column ‘O’ in VBA code is optional; I could do it manually, if necessary)
Thank you in advance for you time and effort.
