One way
=OFFSET(Sheet2!$B$6,,COLUMN(A:A)*4-4)
copy across
Regards,
Peo Sjoblom
"Tracey" wrote:
I am trying to copy formulas in a spreadsheet that pulls the data from every
4th column in another spreadsheet in a consistent pattern (eg. b6, f6, j6,
n6). When I try to copy the pattern to the next 4 cells in the row,
anticipating r6, v6, etc. instead it repeats as f6, j6, n6, r6. How do I
correct this?
|