Hi all.

In my spreadsheet, I'd like to have some sheets (not all) which name is
dependent from the value of a cell inthe main sheet..
For example,
if cell A1 of sheet "Main" is equal to "Stage 1",
I'd like to have another sheet to be named "summary for Stage 1"..
if I'd change the A1 cell in "Stage A", then the sheet name should
change in "summary for Stage A"
I think I need a macro for this, but I don't know where to start
from..
any help is really appreciated..
thanks


--
pimar
------------------------------------------------------------------------
pimar's Profile: http://www.excelforum.com/member.php...fo&userid=5386
View this thread: http://www.excelforum.com/showthread...hreadid=474385