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