Worksheet Names = Cell

[latchescmk]

Is there a way to use cell output to dictate the name of a worksheet. I am trying to creat worksheets that have the date as a name. I would like to have the name of the work sheet linked to the cell that contains the date.

Thanks

 

[Clyde38]

Try ASAP utilities. It's free and it has many other features.

http://www.asap-utilities.com/

 

[johnwm]

Simple macro will do it

 Sheets(1).Name = Range("a1").Value

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints

 

[johnwm]

latchescmk

Did any of these solve your problem?

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints