Dragging Formulas

[Dave]

I'm trying to pull data from one sheet that exists in
every third cell, and place it into another sheet in
consecutive cells. Of course, once my initial cell
reference is made and I drag across the page, the cells
reference connsecutively. Is there a way to drag these
references across and reference every third cell (such as
H, K, N, Q, etc).

Dave

 

[Ken Wright]

With your data in A1, D1, G1, J1 etc on sheet 2, the following pasted into cell
A1 on Sheet1 and copied across will put all the entries together consecutively:-

=OFFSET(Sheet2!$A$1,,(COLUMN()-1)*3)

With your data in B1, E1, H1, K1 etc on sheet 2, the following pasted into cell
A1 on Sheet1 and copied across will put all the entries together consecutively:-

=OFFSET(Sheet2!$A$1,,((COLUMN()-1)*3)+1)