Hi there, I'm looking for help on solving an issue I can't use the macro recorder for but I know I'm in the right place.
- I have a tab named a date which always falls on a monday ie. "9 July"
- I need to copy this sheet over but rename itself 7 days after the most recent date that always falls on a monday ie. "16 July"
Any help would be muchly appreciated.
Reply With Quote