software

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


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 amp;
then,
choosing Insert - Copied Cells [alt i e] amp; [enter] (if needed).

hth
Rob Brockett
NZ
Always learning amp; the best way to learn is to experience...--
broro183
------------------------------------------------------------------------
broro183's Profile: www.excelforum.com/member.php...oamp;userid=30068
View this thread: www.excelforum.com/showthread...hreadid=522114