t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi All,
I have a a workbook with two tabs - Main Sheet and Schedule Tab, the events listed in a table on Schedule Tab (example below) show on the Main Sheet within the following cells based on the date selected. Whilst this works a treat I am trying to figure out how to let users delete events from the Schedule Tab. My idea was that if they select the Event Title Cell on the Main Sheet and click a delete button a macro would search the table on Schedule Tab for values matching the Event Title and corresponding date and then delete that row from the table. Does anyone know a way of doing this?
Schedule Tab
Main Sheet
I have a a workbook with two tabs - Main Sheet and Schedule Tab, the events listed in a table on Schedule Tab (example below) show on the Main Sheet within the following cells based on the date selected. Whilst this works a treat I am trying to figure out how to let users delete events from the Schedule Tab. My idea was that if they select the Event Title Cell on the Main Sheet and click a delete button a macro would search the table on Schedule Tab for values matching the Event Title and corresponding date and then delete that row from the table. Does anyone know a way of doing this?
Schedule Tab
Main Sheet