On the worksheets, clicking the new sheet button will make a sheet for yesterday's (or an entered) date
Sheet 1 performs as needed - when the new sheet button is activated a new sheet is created and some data is copied and moved as I need it done.
Sheet 2 is saved as macro enabled and has a problem. Once the macro is run a visible copy of the page shows up with the date shown as a copy of the old date instead of the new one. This requires clicking "OK" on a naming conflict for several regions.
What do I need to do to fix this?
The sheet was created in Excel 2003 and is being run in Excel 2007
Please Login or Register to view this content.
Bookmarks