Hello all,
I am trying to write a VBA code to copy values of certain cells from Worksheet A into a single row in Worksheet B; and every time I press on the "copy" button, the same cells in Worksheet A should be copied into the next row on worksheet B.
For example, I want to copy the following cells from Worksheet A with this specific order: M1, H6, C9, L8, N8, L13, L15, L16, L17, C30; into Worksheet B as a single row. I.e. After being copied into Worksheet B, cell A2 will have the value of M1, cell B2 will have the value of H6, cell C2 will have the value of C9, etc....
Any attempt at solving this issue will be appreciated.
Thank you,
HB
Bookmarks