Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically shift chart data range | Excel Discussion (Misc queries) | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
Delete data if not within date range | Excel Programming | |||
DELETE DUPLICATE DATA IN A SHEET AUTOMATICALLY | Excel Discussion (Misc queries) | |||
Setting chart data range automatically | Excel Programming |