Hi Jane,
This could be done with a macro but first up see if the following works
for you:
copying your cells/rows [ctrl + c],
selecting the top left cell where you want the cells to be pasted &
then,
choosing Insert - Copied Cells [alt + i + e] & [enter] (if needed).
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=522114