Hi all
I have a spreadsheet which links to loads of others.
As all spreadsheets are the same format it was fine for the first link to be 'autofilled'. Now as i want to copy down the data it obvisouly changes the cell references...
Is there any way - short of doing it manually! - of inserting the $ for letter and number automatically?
Many thanks
J
Bookmarks