Excel formula help,,,,
Discussion
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
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
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff