I started a new job and inherited a roster of 500 employees. the woman who created it has two sheets in the book - one an alphabetical listing of the staff with the following 10 fields
[TABLE="width: 914"]
<tbody>[TR]
[TD="class: xl63, width: 141"]NAME
[/TD]
[TD="class: xl63, width: 64"]WKR #[/TD]
[TD="class: xl63, width: 82"]PHONE #[/TD]
[TD="class: xl63, width: 64"]POS. #[/TD]
[TD="class: xl64, width: 170"]ITEM #/CLASSIFICATION[/TD]
[TD="class: xl63, width: 97"]FUNCTION[/TD]
[TD="class: xl63, width: 64"]MAIL STOP#[/TD]
[TD="class: xl63, width: 104"]LANGUAGE[/TD]
[TD="class: xl63, width: 64"]N.O.S.[/TD]
[TD="class: xl63, width: 64"]CU/RM[/TD]
[/TR]
</tbody>[/TABLE]
The other, formatted for distribution to staff, has work group/unit titles, and the names are listed by function. The fields are slightly different
[TABLE="width: 661"]
<tbody>[TR]
[TD]Wkr.[/TD]
[TD="colspan: 2"]Phone Number[/TD]
[TD="colspan: 2"] Staff Name[/TD]
[TD][/TD]
[TD]Pos. #[/TD]
[TD="colspan: 2"]Item # / Classification[/TD]
[TD]FUNCTION[/TD]
[TD] Mail Stop#[/TD]
[TD]Bi-linqual[/TD]
[/TR]
</tbody>[/TABLE]
What is killing me is that they aren't linked in any sort of way, and I must MANUALLY type in new staff, phone number changes, etc on both sheets. MANUALLY. This is making me feel crazy. There has to be a way to set this up to pull the data from the alpha list and put it into the format which is distributed to staff without manually inputting the same data twice.
Any ideas? Is Excel even the best tool to use for this or should I be looking into something else? My boss is willing to spring for whatever I need, but I'm not sure what that might be.
Help!
[TABLE="width: 914"]
<tbody>[TR]
[TD="class: xl63, width: 141"]NAME
[/TD]
[TD="class: xl63, width: 64"]WKR #[/TD]
[TD="class: xl63, width: 82"]PHONE #[/TD]
[TD="class: xl63, width: 64"]POS. #[/TD]
[TD="class: xl64, width: 170"]ITEM #/CLASSIFICATION[/TD]
[TD="class: xl63, width: 97"]FUNCTION[/TD]
[TD="class: xl63, width: 64"]MAIL STOP#[/TD]
[TD="class: xl63, width: 104"]LANGUAGE[/TD]
[TD="class: xl63, width: 64"]N.O.S.[/TD]
[TD="class: xl63, width: 64"]CU/RM[/TD]
[/TR]
</tbody>[/TABLE]
The other, formatted for distribution to staff, has work group/unit titles, and the names are listed by function. The fields are slightly different
[TABLE="width: 661"]
<tbody>[TR]
[TD]Wkr.[/TD]
[TD="colspan: 2"]Phone Number[/TD]
[TD="colspan: 2"] Staff Name[/TD]
[TD][/TD]
[TD]Pos. #[/TD]
[TD="colspan: 2"]Item # / Classification[/TD]
[TD]FUNCTION[/TD]
[TD] Mail Stop#[/TD]
[TD]Bi-linqual[/TD]
[/TR]
</tbody>[/TABLE]
What is killing me is that they aren't linked in any sort of way, and I must MANUALLY type in new staff, phone number changes, etc on both sheets. MANUALLY. This is making me feel crazy. There has to be a way to set this up to pull the data from the alpha list and put it into the format which is distributed to staff without manually inputting the same data twice.
Any ideas? Is Excel even the best tool to use for this or should I be looking into something else? My boss is willing to spring for whatever I need, but I'm not sure what that might be.
Help!