L
Legacy 138945
Guest
I’m looking for <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> 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 <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> 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 <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code is optional; I could do it manually, if necessary)
Thank you in advance for you time and effort.