Hello,
I am looking for a macro that will allow me to copy and paste the contents of a couple of cells in one row into another row. Here is what I need to do....
I want to take the data in positions B3 to I3 and paste it into cells B408 to I408. I then want to take the data in J3 to Q3 and put it in A409 to H409. This process will continue taking 8 cells from a row and pasting them in the next consecutive row.
If this is unclear feel free to e-mail me at cclewell@fciconnect.com for clarification. Thanks a Heck of a lot for your help,
Craig
I am looking for a macro that will allow me to copy and paste the contents of a couple of cells in one row into another row. Here is what I need to do....
I want to take the data in positions B3 to I3 and paste it into cells B408 to I408. I then want to take the data in J3 to Q3 and put it in A409 to H409. This process will continue taking 8 cells from a row and pasting them in the next consecutive row.
If this is unclear feel free to e-mail me at cclewell@fciconnect.com for clarification. Thanks a Heck of a lot for your help,
Craig