Row reference increment but preserve column reference
Hi,
I need to refer to another workbook using:
='[120 RANDOM WORDS.XLS]GROUP 3'!$A83
I need to import data from A83-A98 from one workbook to another, but across
a row (ie. autofill does not work). How can i adjust the formula so it
increments the row number but not the column? thanks
|