Fill down non consecutive formula from one sheet to another

[android1]

Hi,

I need to fill down the formula in cells A1, A5, A9, A13, A17, A21, A25 from Sheet 2 into cells A1:A6 in Sheet1. Attached Workbook should hopefully explain exactly what i need.
https://www.dropbox.com/s/6d7ypsj10gnl6z1/book2.xlsx?dl=0

 

[android1]

Hi,

I need to fill down the values in cells A1, A5, A9, A13, A17, A21, A25 (increases by 4 each time) from Sheet 2 into cells A1:A6 in Sheet1. Attached Workbook should hopefully explain exactly what i need.
https://www.dropbox.com/s/6d7ypsj10gnl6z1/book2.xlsx?dl=0

To explain this better. I need the values in Sheet2 in Sheet1 without having to copy this -> A1=Sheet2!A1 each time.

 

[Eric W]

I couldn't look at the workbook, but is this what you're looking for?

A1: =INDEX(Sheet2!$A:$A,((ROW()-1)*4)+1)

Put that in A1 and drag down. I also noticed that you listed 7 values to go in 6 cells.

 

[android1]

I couldn't look at the workbook, but is this what you're looking for?

A1: =INDEX(Sheet2!$A:$A,((ROW()-1)*4)+1)

Put that in A1 and drag down. I also noticed that you listed 7 values to go in 6 cells.

Thank you very much Eric. Yeah, I did list an extra value. Thanks a million for this.

 

[Eric W]

You're welcome.