The usual way is to use OFFSET(), but know what your formula is makes it
possible for somebody here to give you clear, concise advice. please post it
so we can better help you


"amoore" wrote:

I need to make a spreadsheet with formulas linking 2 pages together. The
formula is a IF formula and, going down the column, is in increments of 4
cells. ie: B4, B8, B12, etc. When I drag to fill the column with the formula
it automatically goes B5, B9, B13, B6, B10, etc. Hoy do I fix this so it is
one continuous stream of formulas incremented by 4 cells without writing in
each one. (long list!!)