I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file.
then select next range (eg. A3 to C3) and paste is to same destination as earlier.
this needs to be done for n no. of rows.
can anyone help with a macro?
Can we create a button or something, so each time we click the button the next row gets selected and copy pasted to desired destination.
PS. the destination is fixed. Only the range selection varies