Copy & Insert from another xls
 

Hi
Jane from Portbury. I have Office 2003 with XP.
I need to copy and insert a varying number of rows (8-30)from one
spreadsheet into another. Pasting will not allow me to INSERT the copied rows
only paste over rows already there, therefore I have to insert the number of
blank rows required and paste over these, this is v v time consuming.
If there is an answer, help please
Thanks
xJane

Copy & Insert from another xls
 

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