ExcelBanter - How can I autofill not using adjacent cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I autofill not using adjacent cells (https://www.excelbanter.com/excel-discussion-misc-queries/262268-how-can-i-autofill-not-using-adjacent-cells.html)

Dan Maddock

How can I autofill not using adjacent cells

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?

All times are GMT +1. The time now is 10:54 AM.