Hi folks
I have a workbook which contains a sheet for each day of the month.
I would like a macro operable from the cover sheet which will do the following.
Read the input date from cell c3 of the cover sheet (this will be manually changed every month)
Put the incrementing date in cell D2 of each sheet
Rename each tab to the incremental date
Example attached
If I read your instructions to the letter, Every sheet would have 1/1/2016 in Cell D2 and you would attempt to name every sheet 01.01.2016. Obviously there is some definition of "incrementing date" I'm not understanding.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hi Dflak
this is a duplicate thread due to a forum error yesterday and has been answered here
http://www.excelforum.com/showthread...06#post4537606
I will mark it solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks