move cell reference down 1 cell and paste it down 15 cells

[plajoie]

i have referenced in sheet 1 cell d37 a number in cell f4 of the sheet survey 1. i would like to copy and paste that reference from survey 1 down 15 cells on sheet 1 while changing the reference from survey 1 by only 1 cell

 

[Rick Rothstein]

i have referenced in sheet 1 cell d37 a number in cell f4 of the sheet survey 1. i would like to copy and paste that reference from survey 1 down 15 cells on sheet 1 while changing the reference from survey 1 by only 1 cell

Assuming this is a VBA question, this single line of code should do what you asked...

Sheets("Sheet1").Range("D31").Copy Sheets("Sheet1").Range("D31").Resize(15)

 

[plajoie]

Assuming this is a VBA question, this single line of code should do what you asked...

Sheets("Sheet1").Range("D31").Copy Sheets("Sheet1").Range("D31").Resize(15)

this is not a vba question. i am cutting and pasting a fomula

 

[Osvaldo Palmeiro]

i have referenced in sheet 1 cell d37 a number in cell f4 of the sheet survey 1. i would like to copy and paste that reference from survey 1 down 15 cells on sheet 1 while changing the reference from survey 1 by only 1 cell

Assuming that 1 cell is 1 cell down ('F5', 'F6', ...) and you're copying the formula from Sheet1 'D37' and pasting it to Sheet1 'D52', 'D67', ... and so on, maybe this formula could work

=INDEX(survey1!F:F,INT((ROWS(A$1:A1)-1)/15)+4)

 

[plajoie]

Assuming that 1 cell is 1 cell down ('F5', 'F6', ...) and you're copying the formula from Sheet1 'D37' and pasting it to Sheet1 'D52', 'D67', ... and so on, maybe this formula could work

=INDEX(survey1!F:F,INT((ROWS(A$1:A1)-1)/15)+4)

that did not work. I got a #ref!. you understand what i need exactly

 

[Osvaldo Palmeiro]

Try checking the spelling of the sheet name. Maybe there's a space in it that I have not considered like 'survey 1'.

 

[plajoie]

Try checking the spelling of the sheet name. Maybe there's a space in it that I have not considered like 'survey 1'.

that did it. you are awesome. you made my weekend