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.