How can I 'fill' a range of cells incrementing the cell reference within a formula
Posted on 2011-03-01
I want to copy a formula in a cell to the cells beneath it by incrementing the cell reference by 6.
For example, here is the formula...
I want to copy down so the next cell adds 6 to the cell reference thus....
...and so on.
I tried using Autofill but it didn't work.
Is there any way of doing this other than manually changing each formula or using VBA ?