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
seperate row for calculations to occur.

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

Any suggestions?

Thank

--
bforster
-----------------------------------------------------------------------
bforster1's Profile: http://www.excelforum.com/member.php...fo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=55711