You could copy it to successive rows (i.e. row6, row7 etc) and then
insert 9 rows between 5 and 6, between (the old) 6 and 7, and so on.

There are other ways, using INDIRECT or OFFSET formulae (see Excel
Help).

Hope this helps.

Pete

On Nov 8, 10:19 pm, fashionroadkill
wrote:
Hello, I need to copy a row and paste it several rows down. I have a formula
='Sheet1'!A5 in row 6, and if I try and paste it 10 rows down in row 16, it
changes to ='Sheet1'!A15 The problem is, I need it to say ='Sheet1'!A6 so is
there a formula I can use that adds only one cell down, instead of the row
number its being pasted on?

I have a list of titles on Sheet1 that I need to be put in rows on Sheet2
and have lines to sign up underneath, but I don't want to have to change each
one to the next cell on sheet1.