G
gseltz
Does anyone know how to do the following
I have two worksheets and am referencing cell C16 in Sheet1 to cell A1 in Sheet2
However if I copy the cell C16 in Sheet1 and paste it into C33 in Sheet1 it now references cell A18 in Sheet2 when I want it to reference A2. I need to do this multiple times for Sheet1 cells C16, C33, C50, C67, C84, etc... And their respective references should be Sheet2 cell A1, A2 ,A3, A4, A5, etc.. they are always 17 cells apart
I can't get this to work with he OFFSET function. Can anyone help
Thanks in advance!
I have two worksheets and am referencing cell C16 in Sheet1 to cell A1 in Sheet2
However if I copy the cell C16 in Sheet1 and paste it into C33 in Sheet1 it now references cell A18 in Sheet2 when I want it to reference A2. I need to do this multiple times for Sheet1 cells C16, C33, C50, C67, C84, etc... And their respective references should be Sheet2 cell A1, A2 ,A3, A4, A5, etc.. they are always 17 cells apart
I can't get this to work with he OFFSET function. Can anyone help
Thanks in advance!