Updating dates on Separate tabs based on date in first tab

**customizedtours** · 04-14-2009, 03:02 PM

I work for a company in which we print out monthly booking sheets. I need help with a formula. Each worksheet is for a seperate day and I would like to change the date on the first tab and have it update the rest of the tabs in the same cell for the entire month. I have attached what the workbook. Can someone please help me with this?

**NBVC** · 04-14-2009, 03:31 PM

Select Sheet T2, hold the shift key down and select Sheet T31.

In F1 enter this formula:

=Tours!$F$1+MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+2,255)-1

then right click any sheet tab and choose Ungroup Sheets

**customizedtours** · 04-14-2009, 04:02 PM

thanks so much. I copy pasted the formula and it upated the month but I still have one problem..I am hoping since you knew that long formula maybe you know the answer to this..When I click on Tours! and change the date..say from April 1, 2009 to May 1, 2009 it does not automatically change the rest of the dates. Is there a way to do that since the formula is there? I had to re-do the entire set of steps to upate it for May. Thanks again...you are saving the day!

**NBVC** · 04-14-2009, 04:06 PM

It did for me.

Is it the exact file you sent? If so, see attached...

Otherwise check that you have you Tools|Options>> View Tab >> Automatic Calculations checked on.

**customizedtours** · 04-14-2009, 04:32 PM

Thank you sooo much. You have just made my life so much easier! Have a great day!

**NBVC** · 04-14-2009, 04:44 PM

You are welcome,

Can you please mark your thread as Solved.?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save