I need to change only the column reference and keep all cell references as i drag down.
My formula is in column C sheet 2.
I reference sheet 1 column B.
Column B in sheet I increases row reference by 20 or 21or 22.
So column C sheet 2 as it goes down would read "sheet 2 B10 - sheet 1 B 20 - sheet 1B 33 etc.
I just want to be able to change the "B" reference to "E" but keep all the rows referenced.
My formula is in column C sheet 2.
I reference sheet 1 column B.
Column B in sheet I increases row reference by 20 or 21or 22.
So column C sheet 2 as it goes down would read "sheet 2 B10 - sheet 1 B 20 - sheet 1B 33 etc.
I just want to be able to change the "B" reference to "E" but keep all the rows referenced.