Holiday

[Jimb0]

Hi Mr Excel Gurus,

Need your help once again.

I'm currently working on a holiday tracker that links with an attendance planner (mad i know).

On the planner, each cell has data validation with a range of drop down options e.g. S, In, Off etc.

The holiday tracker simple has a date and agents on holiday for that date.
e.g.
24th March: Agent 1
25th March: Agent 2
26th March: Agent 3

What I need to do is link both sheets so if an agent appears on the holiday tracker, it will overide the validation in the attendance planner and put an "H" in the cell (hope this is clear)

I have an idea of a macro that might, but can't seem to get it right.

Please help if you can.

Thanks in advance

 

[GlennUK]

Even if you can't get your macro right, post what you've got so far, and what problems you're facing with it, and people will be able to chip in with ideas.