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.
-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!