Excel formula help,,,,

[tvradict]

Need some help with a formula in an Excel workbook.

I've got a Cell, which I want to do one of 2 things depending on the value in another cell.

I'll explain as best I can. The Cell I need the formula in is C6. There is information in D6 - G6. H6 will be a Yes or a No in it. (Could do with having that in a drop down menu but cant work it out)

Now. heres what I need.

If someone enters a 1 in C6, and there is a No in H6, I need all the information from D6 - H6 to be deleted.

If Someone enters a 1 in C6 and there is a Yes in H6 I need all the information E6 to H6 Saved and D6 deleted!

can it be done??

TIA
Stuart

[tvradict]

Sorry, that was unclear, I just need the data left in the spreadsheet rather than saving the workbook.