Hi,

I want to copy a formula across columns, however the first column has this
formula
=+IF(A2"",A2,"") The next column the reference is C2, then F2 and then H2.

When i highlight all four cells and drag i don't get the sequence repeating.
Is there a way i can do this. Don't really want to manually edit all cells.

Cheers
--
Nenagh