macro to automatically date sheet tab

Jackie · #11 05-23-2015, 11:22 PM

I have attached my work book.

I would like help with my macro so the tabs date automatically when sheet 2 cell B5 has a date entered. At the moment I have to click on a cell in each sheet before the tab dates change/show

On sheet 2 there is a table of dates.

I would like sheet 3 tab to show the date from cell B5 from sheet 2

I would like sheet 4 tab to show the date from cell B6 from sheet 2

I would like sheet 5 tab to show the date from cell B7 from sheet 2

I would like sheet 6 tab to show the date from cell B8 from sheet 2

Many Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to fetch data from one sheet to another with complete details and date wise as well	harisjawed86	Excel Programming	1	08-05-2014 09:10 PM
how to automatically copy parts of a record to another sheet?	kmeechan	Excel	1	05-28-2014 02:24 AM
How to copy data automatically to particular sheet?	nicholes	Excel Programming	13	03-12-2014 01:05 AM
How to automatically insert DAY instead of date?	kylera	Word	3	06-28-2012 12:38 PM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM