Hi all,

Hoping your combined geniusnesseses will be able to help me out with this - have had a good trawl through the forum and not found an answer which is enough to help me get this done.

So,

I have a workbook with data in (rows of people with details). I have a column (f) related to activity status - if a person leaves, the user can select active or vacant (using a validation lookup list). What i would like to do is clear the cells in column G, H and L for just that relevant row.

Any thoughts would be extremely gratefully received.

Many thanks,

Fergcu