stolenweasel
New Member
- Joined
- May 29, 2023
- Messages
- 8
- Office Version
- 365
- 2021
- Platform
- Windows
I have a sheet that I am trying to automate that we use for each day of the month. Right now we have a seperate file for each day that contains one sheet/tab. The sheet is dated in the top right in cell H2. I would like the script to populate either a new file per day with the name of the file being mm dd yy and also populating the corresponding date in H2 for each day. Im not opposed to one file for the month with 28+ days as tabs. The tabs would need to copy the sheet, be named for the dates and also rename H2 to the corresponding date.