Ok, so I obviously wasn't an Excel jockey before.
$A$1 means always refer to cell A1 and don't update the cell reference when copying.
Sheet4! means this reference is in sheet for of the same workbook. Haven't found a way to put a reference in front of the bang (a la A3! where the text of the worksheet is found in A3).
No comments:
Post a Comment