Hi all, im a competant (but fairly basic) excel user, but need a little help here.

I have attached a screenshot of the sheet i am dealing with...
Column F contains a drop down box containing the types of call recieved,and im trying to get it so that when 'hang up' is selected cells D*,E*,I*,J* (* used to replace row value as it will change) will auto popluate with the information shown and get G*, and H* to auto populate with the current date and time respectively.
but everything else needs to remain blank when any of the other options are selected.


I use a new sheet each month, some months this sheet can contain 200 rows, others 2000 depending on certain variables.
Ideally i would like the cells that are to be populated to remain empty (i think i could normally use an =IF formula?) as the sheet is used by some fairly incompetant people so i dont want them throwing a panic if they see a formula, or deleting it.

oh, and it is seen by directors etc so needs to look good :p


I hope ive included all the information i need? please let me know if you need anything else??