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


--
Petitboeuf
------------------------------------------------------------------------
Petitboeuf's Profile: http://www.excelforum.com/member.php...o&userid=10602
View this thread: http://www.excelforum.com/showthread...hreadid=562366