Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total Newbie Needs Help
Having only ever used Excel as a simple spreadsheet I need some help
with a task I have been given in work. Our business centre has 60 staff spread across 7 teams. Each Team has a holiday spreadsheet made up of 13 worksheets, one for each month and an annual total. This has always sufficed but recently their have been a number of changes to the personnel structure in the office which has meant people moving from one team to another. As I am sure you can imagine, the time taken to "transfer" someone from one spreadsheet to another stacks up! Can anyone give me a push in the right direction of how to set this up? I had thought of having all of the staff and all the 12 months on one worksheet. Each member of staff has a team leader. I hoped then to put a combo box control on the worksheet which contained the teamleaders names and when a team leader is selected the worksheet filters the records to show just their team. That way if anyone moves it is just a case of amending their team leaders name. I have got as far as adding the combo box but have no idea how to populate it with the teamleaders names or how to make the worksheet filter on the selected name. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total Newbie Needs Help
If it is on one sheet try using an autofilter to select the data required
"David Mitchell" wrote in message om... Having only ever used Excel as a simple spreadsheet I need some help with a task I have been given in work. Our business centre has 60 staff spread across 7 teams. Each Team has a holiday spreadsheet made up of 13 worksheets, one for each month and an annual total. This has always sufficed but recently their have been a number of changes to the personnel structure in the office which has meant people moving from one team to another. As I am sure you can imagine, the time taken to "transfer" someone from one spreadsheet to another stacks up! Can anyone give me a push in the right direction of how to set this up? I had thought of having all of the staff and all the 12 months on one worksheet. Each member of staff has a team leader. I hoped then to put a combo box control on the worksheet which contained the teamleaders names and when a team leader is selected the worksheet filters the records to show just their team. That way if anyone moves it is just a case of amending their team leaders name. I have got as far as adding the combo box but have no idea how to populate it with the teamleaders names or how to make the worksheet filter on the selected name. Help! ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
total dumb newbie question | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |