G
Gemz
Hi,
I have a cancelled appointments userform, if someone cancels their
appointment the user will enter their name, appt time etc in a userform and
this info is then stored into a cancellations sheet in the spreadsheet, this
bit is fine. what i want to do next is if this info is enterted into the
cancellations sheet the code should somehow recognise the info being put in
and delete this info in the appointments sheet. so this info would already
have been in an appointments sheet but because now its cancelled it then goes
into a seperate sheet called cancelled appts. but i would now like for the
code to delete the exact same info from the appointments sheet and if its
possible alert the user that an appointment slot is now available and say the
time/say of the cancellation. i dont want this bit to be manual because at
the moment when a cancellation is made the user enters the stuff into the
cancellation sheet but then has to manually search that record in the
appointments sheets and mark it as cancelled.
is this atol possible? i checked some websites as recommended but didnt find
anything like this.
thanks.
I have a cancelled appointments userform, if someone cancels their
appointment the user will enter their name, appt time etc in a userform and
this info is then stored into a cancellations sheet in the spreadsheet, this
bit is fine. what i want to do next is if this info is enterted into the
cancellations sheet the code should somehow recognise the info being put in
and delete this info in the appointments sheet. so this info would already
have been in an appointments sheet but because now its cancelled it then goes
into a seperate sheet called cancelled appts. but i would now like for the
code to delete the exact same info from the appointments sheet and if its
possible alert the user that an appointment slot is now available and say the
time/say of the cancellation. i dont want this bit to be manual because at
the moment when a cancellation is made the user enters the stuff into the
cancellation sheet but then has to manually search that record in the
appointments sheets and mark it as cancelled.
is this atol possible? i checked some websites as recommended but didnt find
anything like this.
thanks.