Hi,
I have an annual leave rota.
Worksheet 1 has three columns containing First Name, Surname and
Department. These are named ranges and update sheets 2 & 3.

Sheets 2& 3 contain details of annual leave.
A = First Name, B=Surname, C= Department D etc = dates.

This will be used by a lot of people and i need it as idiot proof as
possible! Is there any way that a manager could click a button and add
a member of staff (which would update the first worksheet). Could they
then click a button, enter a name and delete that member of staff from
the list? If that is possible, could the macro then delete the whole
row in worksheets 2 & 3 (the dates that person is on leave).

Thanks in advance for any help.
Paula.