Hi
I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work.
Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into the next cells.
What I need it to be able to do is for when a new price and a new date gets inputted then for the quote price and date to be cleared.

Within my spreadsheet the quote price is in row D, quote date is in row E. The sale price is in row F and sale date is in row G.

Any help on this would be much appreciated.
Thanks
Adam

This needs to be done using VBA. You can probably record a macro to clear the cells in D & E, but then you will need to setup a trigger to run it when something is entered in either F or G.