Hello!
Firstly I apologise for the vague title!
I have a spread sheet which I a using as an individual user booking form, to explain the background I work for a company which requires "floor walkers" to aid other members of staff.
To ensure the planning of this time is correct and that a floor walker cannot be double booked I created a "booking form"
Currently the person wanting to book the individual looks on a preloaded sheet for the month they want "January" for example.
They then look at the individual peoples "availability" and then return to sheet 1, which contains the booking form, the person inputs the name of who they want with the date and time and then hits submit.
I currently have a macro that copies the booking form information and then pastes it into a "collation" sheet as well as emailing the "floor walking" team to state who has been booked and for when / what.
I then have to manually go into the form and go into the month and change them from "available" to "booked out".
So that's the background covered...
here is my question!
Is there anyway of me building in something so when they hit the "submit" button it firstly checks the month which has been entered for the word "available" if "available" is true then allow the code to run and then change that cell to "booked out"?
to try and explain the spread sheet I have attached a copy to try and help make sense of what I am asking (the code might not work for you guys but the form is only to see if my idea is possible?) its also password protected but you can still see the code and the pages.
Any advice would be greatly appreciated
Bookmarks