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!