PC Review


Reply
Thread Tools Rate Thread

Automatically add/ delete data from range

 
 
sodhouse
Guest
Posts: n/a
 
      30th Jul 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically shift chart data range: redux Sean Clayton Microsoft Excel Misc 6 28th Jul 2010 08:17 PM
Automatically shift chart data range Sean Clayton Microsoft Excel Misc 4 22nd Apr 2010 10:55 PM
Data Range updating automatically as new data is entered mgnrke28 Microsoft Excel Charting 1 10th Jul 2008 02:02 PM
Setting chart data range automatically LoucaGreen Microsoft Excel Programming 4 28th Jul 2004 02:16 AM
Setting chart data range automatically LoucaGreen Microsoft Excel Charting 4 27th Jul 2004 02:06 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:00 AM.