somewhere you need some common element that links the people on the first
sheet to their respective mailstops on the second sheet.

As an example
If I gave you a list of just nfl player names and a list of nfl teams and
asked you to organize lists of complete team rosters, what would your
response be? Obviously how do I know who is on which team. Same with your
data. That link may very well exist in your data, but you haven't said
where or what it is.

--
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.