Long and complicated "phone list"...list!

Cupid

New Member
Joined
Jul 20, 2006
Messages
36
Hi gang.
Ive been working on a rather large project for my work friends over the past.

This test basicaly catalogues all the data from each 5 "task's" from each employee each day over the whole year.

Theres 1 start page listing the team manager, team leaders and each employee, with hyperlinks to the individual sheets

there is 1 team manager and 4 team leaders and upto 40 employees per team leader.

Each employee has there own seperate sheet to catalogue the data collected from each "task" every day, seperated into each month and each month the employee trys to meet individual "task" goals.

Each Team leader has a summery for there 40 employees
and the Team manager has a summery showing the team leaders overall data.

to see what i meen, ive uploaded the whole excel file here
http://www.box.net/public/zbcd43l05r
carefull its a big file 6+mb
*****************************************************

After dooing all this, Ive been given another task with Excel,
To make a dynamic "Phone list"

I'm not sure where to start with this one, as our current phone list is Soooo messy

Basicaly its as follows
7 excel forms, each one with multiple "tabs"
each excel form = an individual "department" within the business
each excel tab = an individual "group" within that department

each "tab" would then have a "list" of Employee names, department code and two telephone numbers

Still with me ? *chuckle*

******************************************

I've been asked to "sort out" this horrid phone list. To make it more "user friendly"
for seartching for an Employee name or department
We do have a "team" who update this list on an eregular basis and they wanted it made easyer to update as well
via some "link?" perhaps next to a name, that would then automatically e-mail to update team with the new details.

Oh and the list is password protected from everyone, but the update team, to stop "certain" people from mucking it all up. *chuckles*

******************************************

If anyone out there could jump on something like this for me and "create" some examples of a dynamic phone list like above, it would be greatly appreciated.

Thanks in advance
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,733
Members
414,170
Latest member
Mdm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top