Delete cell content when another cell is changed

[jimmisavage]

Hi all,
On my 'Home' sheet i have a list of names in column A and some dates in column H.
On my 'AfterAppointment' sheet I have some information copied from 'home' sheet. For example column F has a simple formula to pull the name from the 'Home' sheet =(Home!A5).

When someone changes a date in the 'Home' sheet I would like to have something in place to delete the data from the cell in columns E & H for that person in the 'AfterAppoinment' sheet.

I hope that makes sense!
Can anyone help with this please?

[AlphaFrog]

To install the code:

• Right-click on the Home sheet tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.

[jimmisavage]

AlphaFrog, you're my hero!!
Thank you very much

[AlphaFrog]

You're welcome. Thanks for the feedback.