| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare 1 cell to column of cells returning adjacent cells info? | Excel Worksheet Functions | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| Autofill cels based on two dates in adjacent cels | Excel Worksheet Functions | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
| Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Linear Mode
