The Friday is cleared too. There are some things that are not clear to me
The Bookings table has a name and address columns B-D
what can be done is that the moment you that after the create jobs macro has run the column E and F can be cleared allowing for new entries there.
If you enter the same for a next run it will ignore these and clear them later too.
The macro will not clear all and keep the existing.
You will probably have to add a macro to clear all for a new month.
Is this the idea?
Bookmarks