From: Dan Maddock Dan on
I have a formula:

=SUM('Daily from Mar 2010'!AZ4:BF4)

In the cell to the right of the above cell I want the formula to be

=SUM('Daily from Mar 2010'!BG4:BM4)

Whenever I try to use autofill it populates the cell with the following
formula instead:

=SUM('Daily from Mar 2010'!BA4:BG4)

I really need it to jump 7 columns instead of just the one. Can anyone help?