I am trying to refference specific cells from one worksheet to another. The
information I need is not in consecutive cells, they are, for example, 4
cells apart.

My problem is I have over 8000 cells that need filling and I am not about to
do that by hand :) When I put a few entries in then try to have the pattern
propogate it doesn't work. instead it backtracks. for example, if I entered
4 cells:
salary!g4
salary!g8
salary!g12
salary!g16

when i try to propogate i get a patern like:

salary!g8
salary!g12
salary!g16
salary!g20
salary!g12
salary!g16
salary!g20
salary!g24

How do i make the pattern consistant over the 8000 cells?