Hello,
Please could somebody show me how to code VBA to copy table values into a single row using VBA - e.g. copy A2:C4 into row E1 to E9 as shown below
I have a number of larger tables to do this with so am looking for some code for the below I can modify to handle these.
Any help much appreciated.
Thank you
Iain
Please could somebody show me how to code VBA to copy table values into a single row using VBA - e.g. copy A2:C4 into row E1 to E9 as shown below
I have a number of larger tables to do this with so am looking for some code for the below I can modify to handle these.
Any help much appreciated.
Thank you
Iain
Cell to be copied | Destination |
A2 | E1 |
A3 | E2 |
A4 | E3 |
B2 | E4 |
B3 | E5 |
B4 | E6 |
C2 | E7 |
C3 | E8 |
C4 | E9 |