inserting required number of rows

  • Thread starter Thread starter saarang
  • Start date Start date
S

saarang

I have a small problem.
I am copying a range of sheets and inserting into a new sheet.

I do know the range that i am copying in each of these sheets.

Is there a way to specify the number of rows that i need to insert

Since i know the range i also know how many rows i am copying so i wan
to shift the rows by that amout.Is that possible??

thanks
s
 
Hi,
Try this:
Highlite the rows you want to copy,
Move to the area you want to paste them into,
Right mouse click where you want them inserted,
Select Insert Copied Cells. The rows will automatically
be shifted down.

HTH
 
You must log in or register to reply here.

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

Copying data to the next blank row 0
Inserting Rows into multiple worksheets 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
how do I insert row keeping formulas from previous row? 1
copy and insert throwing error- help in code req 8
Insert row on multiple sheets 6
Adding a specified number of rows in Excel, via a User Form 0
How can my formula handle inserted rows? 3

Back
Top