Again, it sounds to me like all that could be done with a pivot table. You
select which cells are displayed and you can select that any single, and
group or all mail stops are shown in the table. The table is dynamice - you
can change the way it looks, print it, change the way it looks, print it and
so forth.

If you don't know how to write code, that seems like a bad solution for you.

--
Regards,
Tom Ogilvy

"Lost" wrote in message
...
Well I see where a pivot table would be helpful, but I was hoping for a
way
just to generate a sheet listing ONLY the mailstop #'s and the people in
them. With that I could just print out every month a list of the people in
those groups. I would also be able to update one sheet while the 3rd
generates only "that specific" mailstop. maybe i am just overlooking it
all
and there might be an easier way, but in the end, all i want to have is a
table list of every departments mailstop without all the BS info, just
their
last and first name.

"Tom Ogilvy" wrote:

If you want them arranged by mailstop number, you can just use a pivot
table
with Mailstop number as a row field and name as another row field.

You can then drag name into the data field as well and select count.

Now create the table, then copy it to another sheet and do a paste
special
so it isn't a pivot table anymore. Then you can get rid of the count
column.

See Debra Dalgleish's site for general information on working with Pivot
Tables.
http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy


"Lost" wrote in message
...
Well actually there is a common value on both sheets, the both have
the
pillar number and also the mailstop number. for example sheet1 does
contain
1122 and B2J, and sheet2 contains the same - 1122 and B2J. does that
help?
Thanks!

"Tom Ogilvy" wrote:

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.