Copy & Insert from another xls

J

JWF

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
 
B

broro183

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...
 
Top