I would like to do the following:
With the code:
='Load Chart Data'!$K2
I would like to be able to increment K2 by 12 each time I drag it to a new cell to the right.
So I drag it to the right and K2 become K14 and so on.
Is this possible? I have over 650 values I need to reference and I don't want to have to manually change each cell by 12 to capture them all. I was hoping I'd be able to drag the formula and Excel would know to add 12 to the cell reference each time.
Bookmarks