Automatically add/ delete data from range
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. |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com