May be a rather strange request, but I have a sheet that has some spots for data input and then off to the side, in column P, I have a reference list of a variety of lengthy text strings. I have to input these into certain cells in the active sheet, so I usually just like to type "=P<row#>" to quickly add in that text. So I'd type =P24 to copy the text in P24 to the spot I want it in the form. Ok not the most elegant but it works nicely for me.
So we have a new sheet format, and it has more columns so now where P used to be it's AH, but I want to know if there is a way I can still use =P somehow? I have plenty of space on the side to add formulas or something if needed.
So we have a new sheet format, and it has more columns so now where P used to be it's AH, but I want to know if there is a way I can still use =P somehow? I have plenty of space on the side to add formulas or something if needed.