My workbook has 53 worksheets, and worksheet #1 is a summary of the next 52
weekly worksheets.
Worksheet #1 (summary) cell B4 contains the formula =DATE(5,1,2) followed
by cell C4 formula =B4+7 , cell D4 =C4+7 , etc through cell BA4, which is
week 52
Worksheet #2 (week 1) cell B4 contains the formula ='2005 Summary'!$B$4
from the summary worksheet #1, followed by
Worksheet #3 (week 2) cell B4 ='2005 Summary'!$C$4 from the summary
worksheet #1, followed by 50 more worksheet linked back to the summary
worksheet.
I would like to label each worksheet tab with the date derived from the
formula in each respective cell B4.
Ken, does this give you the exact range information you need?
Thanks
"Ken Wright" wrote:
Where exactly are the dates that you want to name the sheets with. Give me
exact ranges, and is it one per sheet etc
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Pat" wrote in message
...
Ken, can you explain further? I do not understand how to run code
through.
I know where the dates are in each of the 52 worksheets I am using in my
workbook that compiles an annual report, and the dates are driven by
formula
from a 53rd worksheet that compiles the info from the weekly worksheets.
I obviously have no programming skills.
"Ken Wright" wrote:
You can't link them as you can't label a tab with a formula, but if you
know
where the dates are for each tab then you can have code run through and
name
each of the tabs based on those values.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--
"Pat" wrote in message
...
How can I link and label worksheet tabs to relative dates contained in
each
worksheet?
|