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.