Get the code to do the copying with the macro recorder.
Bear in mind you can define a range with variables like this:
Dim i As Long
Range(Cells(i, 1), Cells(i, 5))
Look in the VBA help at the For Next loop.
Combine the three.

RBS

"bforster1" wrote
in message ...

I am sure this will be easy for the experts.

I have 500 rows of data and each one seperately has to be copied to a
seperate row for calculations to occur.

More specifically I want the 1st row, 5 columns, to be moved to the
other cells for calculations and then it moves, loops, to the next row
which are moved to the cells for calculations, and so on 498 more
times.

Any suggestions?

Thanks


--
bforster1
------------------------------------------------------------------------
bforster1's Profile:
http://www.excelforum.com/member.php...o&userid=11771
View this thread: http://www.excelforum.com/showthread...hreadid=557112