Name a tab

[pdizzy]

Hi

Is it possible to have a worksheet tab that will change according to what's in a specific cell? I have a monthly Workbook and a sheet for each date (excluding weekends). Cell B2 has the date and I would like the value of B" to appear as the tab name.

I am using Excel 2002.

Thanks in advance.

PD

[Draconi]

Hi pdizzy,

I think this is what your looking for.

Please Login or Register  to view this content.

Attached is a sample.