Comparing fields to output results

Thanks for the reply. Prehaps if I explain a little more with an example, a person runs a small support company and wants to monitor telephone use of her staff. So basically each staff member has a phone at their desk. In my example RED, BLUE & GREEN are the staff members.

Each month she recieves the bill of each staff member. The rule is each member of staff must call customers so many times each month. The customers are Jim, John, Fred, Joe etc.

Each customer has their own phone number.

Each month the callers and their telephone numbers are entered manually into an excel document.

RED calls Fred on 1111 & Jim on 2222
BLUE calls Joe on 3333 & Jim on 2222
GREEN calls Fred on 1111, Jim on 2222, Joe on 3333

The new worksheet (OUTPUT) with automatically populate with:


Column A Column B Column C

Fred 1111 Red, Green
Jim 2222 Red, Blue, Green
Joe 3333 Blue, Green

OUTPUT TO LOOK LIKE THE ATTACHED IMAGE



As a new sheet is added for a new member of staff so it will populate to OUTPUT.


In answer to the questions:

1. As above, I will create the worksheets but I want Excel to populate the OUTPUT sheet as each new staff member is given a new worksheet. The colours of the tabs are not relevant, I just used them to highlight the point

2. Enter manually each time

3. As above, a new sheet for each new staff member, once a week or month



Thanks again

Piers

Piers,

I know this is an excel forum, but I think there are better ways to accomplish this task. I would recommend that you visit www.google.com/docs.

Please register... you do not have to create an email account... simply it gives you the option to choose one you already have. When you get to your main screen in google docs, In the menu, click on "New" and select spreadsheet. Once the spreadsheet opens at the top in red bold letters is going to say "New Features"... look through the list for the section about creating forms.

Google forms are very easy and anyone with an Internet connection can use it. Since you are going to be the admin, it is your task to create/design the form, which will link to a spreadsheet. Creating the form is easy as 1-2-3 and you get the results in real-time rather than waiting for people to have time to access and update the spreadsheet and you running after them. I tried this at work with a task similar as yous, and it is working like a charm... not only that, but it has a timestamp feature that lets you know exactly when someone submitted information.

In your case the form will have three fields (Staff Name, Client, Phone) and you can export the file into your computer to do real excel analysis.

Think about it

Regards,
nrage21