Of course, maybe what your boss wants is for you to sit down and build that
list by finding out where people sit and writing down their mailstop. No
computer program can invent information where the supporting facts don't
exist.

--
Regards,
Tom Ogilvy

"Lost" wrote in message
...
Well what would i need to tie them together? something common in each
sheet?
i am super new to excel in this fashion and just want to say thanks for
being
patient with me.

"Tom Ogilvy" wrote:

You haven't shown anything that ties John Smith or anyone else to Mail
stop
1122

--
Regards,
Tom Ogilvy

"Lost" wrote in message
...
I am still...looking for some serious help to automate certain tasks
in
Excel. I do a report for a mailroom and I responsible for tracking and
updating certain functions of our department. Here is the deal;

Sheet1 contains employee info (ie. Column C is First Name, Column D
Last
Name, etc.) by columns and Sheet2 contains columns that contain Mail
stop
info (ie. Building, Floors, Pillar #, and Mail stop #) by columns.

Now what i want to do is make Sheet2 create a list of people by Last
Name
then First Name at specific Mail stops. So basically I would like to
see
my
info like this (ie. John Smith at Mail stop 1122, John Doe at mail
stop
1122);

Mail stop for everyone in that group in cell A1 - (ie. 1122)
Cell A3 would contain the Last Name - (ie. Smith)
Cell B3 would contain the First Name - (ie. John)
Cell A4 would contain the Last Name - (ie. Doe)
Cell B4 would contain the First Name - (ie. John)

And then it would go to the next person at the same mail stop with the
listing 1122, and so on and so forth that are on Sheet1. I would also
like
it
to update (add / remove) people as new or old employees are added or
removed
to the mail stop. I am SO grateful for the help.