inserting required number of rows

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
 
M

mzehr

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
 
Top