Another question:

Main sheet has list of values in col A starting with A2, e.g.

AAL
ABF
ABG


I want to create a reference so that cell A1 in Sheet 2 of the workboo
links to A2 in the Main sheet, i.e. "AAL". A1 in Sheet 3 would link t
A3 in the Main sheet, i.e. "ABF", and so on. Given that there are 300
sheets, I don't want to do this manually. If any of you can help, I'
really appreciate it.

Bertie

--
claytor
-----------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...fo&userid=1161
View this thread: http://www.excelforum.com/showthread.php?threadid=48024