I need to copy a load of rows of cells which contain various relative formulas and to past them in a different location but with those same cell references as in the original location.
I understand that the '$' char does this at an individual level, but how can i do this with a bul cut/copy & paste?
Thanks