Monthly to Daily Schedule Automation Help [Closed]

Report
Posts
4
Registration date
Thursday September 1, 2016
Status
Member
Last seen
September 6, 2016
-
Hello,
  • I am posting this again as I believe there were some issues with my original post. Thanksin advance!*


I am looking for some assistance outputting data from a monthly calendar to individual daily schedules. I inherited this project that initially didn't use any of Excel's capabilities. All information was copied and pasted from the monthly spreadsheet to the daily spreadsheet, which is tedious and has a large margin of error.

I have managed to link data between sheets and automatically update the date on each tab (the real document has a tab for each day of the month). However, after stumbling upon this article (https://ccm.net/forum/affich-910283-a-macro-to-create-new-copy-and-name-worksheets-based-on-a-list#q=Excel+-+A+macro+to+create+and+name+worksheets+based+on+a+list&cur=2&url=/), I believe there are some very smart people here that might have great ideas to help with this project.

The demo sheet I created for you to look at is here: https://www.dropbox.com/s/0u5eeyj2ioj26ko/schedule%20for%20upload.xlsm?dl=0 In an ideal world, I'd like to learn how to make the spreadsheet do any of the following:

-automatically create worksheets by date
-automatically populate the date on each worksheet
-link data from Monthly calendars to daily schedules
-On the daily schedules, link data from columns F-I to the corresponding spaces in columns A-D. (Currently, we update this manually each day.)

I understand you're all volunteering your expertise, so I'm appreciative of any advice you can offer. Thanks in advance!


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!