Copy & Insert from another xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Selection copy and insert to other sheet 1
Selection copy and insert to other sheet (Macro) 8
Copy & Paste 1
Insert rows and copy forumla above it 3
Need Macro- Insert rows based on dates and copy info from that row 1
Still Another Copy-and-Paste Macro Problem 3
cell returning totals of 2 cols+ sending this value to another col 5

Back
Top