Still Lost
 

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.

Still Lost
 

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.

Still Lost
 

The task you have is not ideal for Excel. Excel is designed for manipulating
and Analizing numbers. What you are describing is a database. Do you have MS
Access, because that would be an infintely better tool for this task. Any
solutions that you will come up with will be a lot of work to create and
maintain.

You are asking what kind of screw driver do I need to pound in this nail.
Can it be done with a screw driver... Probably, but why would you want to go
to all that effort when you just need a hammer.
--
HTH...

Jim Thomlinson


"Lost" wrote:

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.

Still Lost
 

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.

Still Lost
 

I totally understand, but my "manager" wanted to go this route, and all the
hammers in the world don't matter if all your boss wants is a screwdriver for
that nail... =0)

"Jim Thomlinson" wrote:

The task you have is not ideal for Excel. Excel is designed for manipulating
and Analizing numbers. What you are describing is a database. Do you have MS
Access, because that would be an infintely better tool for this task. Any
solutions that you will come up with will be a lot of work to create and
maintain.

You are asking what kind of screw driver do I need to pound in this nail.
Can it be done with a screw driver... Probably, but why would you want to go
to all that effort when you just need a hammer.
--
HTH...

Jim Thomlinson


"Lost" wrote:

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.

Still Lost
 

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.

Still Lost
 

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.

Still Lost
 

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.

Still Lost
 

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.

Still Lost
 

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.

Still Lost
 

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.