Hi all,


I need a excel macro to copy the 3 rightmost columns to next 3 columns.


Eg.


if i have data from column A to Column G then I need to copy the data from Column E to Column G to copied to
Column H to Column J.

I cant hardcode the column names in macro as the column range may vary day to day.

Is there any way this can be done in an excel macro.

Please help me in this issue