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.

Yes it is possible, but you probably will not get many suggestions without
providing some specific details about which rows and columns contain which
data. Remember, we cannot see your sheets.

"Gemz" wrote:

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.

Hi,

The cancelled appts sheet is called 'cancellations', the new appts sheet is
called 'appointments'.

When info is entered into userform cancellations (there are 3 text boxes in
this form - Name, cancelled time, day) this info goes into sheet
cancellations into the first available blank cell and paste the info there.
This info should then be recognised by excel to be a cancellation and it
should then do a search by appointment time and day and recognise an entry in
the appointments sheet and highlight it/delete it and bring up a pop-up
message saying a new appointment slot is now available and show the time and
day available.

Do u need anymore info?

thanks for your help, really appreciate it.

"JLGWhiz" wrote:

Yes it is possible, but you probably will not get many suggestions without
providing some specific details about which rows and columns contain which
data. Remember, we cannot see your sheets.

"Gemz" wrote:

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.