Help Only Deleting Table Rows

Hi All,
I am hoping someone can help guide me to make this work!

I am using the calendar spreadsheet (link below) to create a team based calendar.

The spreadsheet has two tabs:
Tab 1 - Calendar
Tab 2 - Schedule

My goal is to have the Schedule Tab hidden from everyone and when someone needs to delete an event from the calendar they would click on the event title on the Calendar tab and click Delete.
The macro would search the table holding the events on the Schedule Tab for the corresponding Date and Event Name and then delete the row from the table NOT the worksheets entire row. I have hacked together the following code which works but it deletes the entire row! My below code filters the table based on the data in the third column, it is formatted to DATE - Event. To run the macro the user needs to select the Event Title within column K.

For the code to work within the spreadsheet I added:

Schedule Tab
Cell H2 - Formula ='Monthly view'!K3
3rd Column of Table Formula = =TEXT([@Date],"dd/mm/yyyy")&" - "&[@Title]

Please Login or Register  to view this content.

https://www.get-digital-help.com/calendar-monthly-view/


Other forum link - https://www.mrexcel.com/board/thread...ction.1144494/

Thanks in advance!
t0ny84

I found that by using the following code it meant that the additional data in the sheet didn't get deleted.

Please Login or Register  to view this content.

instead of below

Please Login or Register  to view this content.