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.