| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Urgent new user needs Macro HELP!
Would anyone have a Macro the help me get the results below?
Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
Would you be able to describe what you want a little bit more. Because it
looks like that mess is in absolutely no order in how it appears. "49niner" wrote: Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
I have data in column A, B, C, etc. The A column consists of different
Agency Names ... the B column is the Last name and the C column is the First name. I need to create a report that list the Agency name once with staff names below it. That mean the Agency name would only printout one time regardless of how many staff members it has associated with it. When it comes to a different Agency it would the same thing. There are many Agencies in the data (1600 records). It has to be sorted by Agency, Last and First names. -- 53214920 "49niner" wrote: Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
You know have you looked in to Pivot tables at all.
You could easily get this done with out having to go through the pain of setting up a macro to cover the 1600 pieces of data. Create a pivot table and add Agency, Last Name, First Name to the left column of the pivot table in that order. If you want to get rid of the rows that say First Name Total then just right click on the first one you see and click hide... do the same for Last Name and you will have a list with all the agencies showing up once with all the last and first names showing up in a list order. "49niner" wrote: I have data in column A, B, C, etc. The A column consists of different Agency Names ... the B column is the Last name and the C column is the First name. I need to create a report that list the Agency name once with staff names below it. That mean the Agency name would only printout one time regardless of how many staff members it has associated with it. When it comes to a different Agency it would the same thing. There are many Agencies in the data (1600 records). It has to be sorted by Agency, Last and First names. -- 53214920 "49niner" wrote: Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
I decided on the Macro route because someone else will be maintaining the
listing. They would be updating when necessary and doing a monthly distribution. This report is a Emergency Notification Listing. I want him to be able to delete and update records and simply run the macro for his report. -- 53214920 "akphidelt" wrote: You know have you looked in to Pivot tables at all. You could easily get this done with out having to go through the pain of setting up a macro to cover the 1600 pieces of data. Create a pivot table and add Agency, Last Name, First Name to the left column of the pivot table in that order. If you want to get rid of the rows that say First Name Total then just right click on the first one you see and click hide... do the same for Last Name and you will have a list with all the agencies showing up once with all the last and first names showing up in a list order. "49niner" wrote: I have data in column A, B, C, etc. The A column consists of different Agency Names ... the B column is the Last name and the C column is the First name. I need to create a report that list the Agency name once with staff names below it. That mean the Agency name would only printout one time regardless of how many staff members it has associated with it. When it comes to a different Agency it would the same thing. There are many Agencies in the data (1600 records). It has to be sorted by Agency, Last and First names. -- 53214920 "49niner" wrote: Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
You're still better off with a pivot table.
Regards, Fred. "49niner" wrote in message ... I decided on the Macro route because someone else will be maintaining the listing. They would be updating when necessary and doing a monthly distribution. This report is a Emergency Notification Listing. I want him to be able to delete and update records and simply run the macro for his report. -- 53214920 "akphidelt" wrote: You know have you looked in to Pivot tables at all. You could easily get this done with out having to go through the pain of setting up a macro to cover the 1600 pieces of data. Create a pivot table and add Agency, Last Name, First Name to the left column of the pivot table in that order. If you want to get rid of the rows that say First Name Total then just right click on the first one you see and click hide... do the same for Last Name and you will have a list with all the agencies showing up once with all the last and first names showing up in a list order. "49niner" wrote: I have data in column A, B, C, etc. The A column consists of different Agency Names ... the B column is the Last name and the C column is the First name. I need to create a report that list the Agency name once with staff names below it. That mean the Agency name would only printout one time regardless of how many staff members it has associated with it. When it comes to a different Agency it would the same thing. There are many Agencies in the data (1600 records). It has to be sorted by Agency, Last and First names. -- 53214920 "49niner" wrote: Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 sheet3 A B C D Agency LastN FirstN XXX DoITT Jones Kay DoITT Smith Bob Confuse Terry Jerry Acme Hook Kathy Acme Fung Jay OEM Mitchell Robert DEP Law Frank DCP Shank Dee OEM Crane Harry Confuse Shockey Jay DoITT Lauben John DEP Water Logged The output to appear as follows: A B C D Agency LastN FirstN XXX Acme Fung Jay Hook Kathy Confuse Shockey Jay Terry Jerry DCP Dee Shank DEP Law Frank Water Logged DoITT Jones Kay Lauben John Smith Bob -- 53214920 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Urgent new user needs Macro HELP!
it looks like you simply want it all sorted by agency name, correct?
can't you just select it all, use Data, Sort, & use column A for your sort key? susan On Mar 3, 2:38*pm, 49niner wrote: Would anyone have a Macro the help me get the results below? Workbook name: *enlformat2 Worksheet name: *enldata * * * * * * * * * * * * * * sheet2 * * * * * * * * * * * * * * sheet3 A * * * * * * * B * * * * * * * C * * * * * * * * D * * * * * * Agency * * * * *LastN * * * * * FirstN * * * * *XXX * * * * * * DoITT * * * * * Jones * * * * * Kay DoITT * * * * * Smith * * * * * Bob Confuse * * * * Terry * * * * * Jerry Acme * * * * * *Hook * * * * * *Kathy Acme * * * * * *Fung * * * * * *Jay OEM * * * * * * Mitchell * * * * * * * *Robert DEP * * * * * * Law * * * * * * Frank DCP * * * * * * Shank * * * * * Dee OEM * * * * * * Crane * * * * * Harry Confuse * * * * Shockey * * * * Jay DoITT * * * * * Lauben * * * * *John DEP * * * * * * Water * * * * * Logged The output to appear as follows: A * * * * * * * B * * * * * * * C * * * * * * * D * * * * * * * * * * * * * * * Agency * * * * *LastN * * * * * FirstN * * * * *XXX * * * * * * * * * * * * * * Acme * * * * * * * * * * * * * * Fung * * * * * * * * * * * * Jay * * * * * * * * Hook * * * * * *Kathy Confuse * * * * * * * * * * * * * * * * * * * * Shockey * * * * * * * * * * Jay * * * * * * * * Terry * * * * * Jerry DCP * * * * * * * * * * * * Dee * * * * * * * * * * * * * Shank * * * * * * DEP * * * * * * * * * * * * * * * * * * * * * * Law * * * * * * * * * * *Frank * * * * * * * * Water * * * * * Logged DoITT * * * * * Jones * * * * * Kay * * * * * * * * Lauben * * * * *John * * * * * * * * Smith * * * * * Bob -- 53214920 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need urgent help on macro merging | Excel Discussion (Misc queries) | |||
| MACRO URGENT HELP | Excel Discussion (Misc queries) | |||
| Urgent need of a power user in Excel to help me build a sprdsht. | Excel Discussion (Misc queries) | |||
| Urgent - Help VBA Macro | Excel Discussion (Misc queries) | |||
| URGENT Mac/PC macro compatibility problem | Excel Discussion (Misc queries) | |||
Hybrid Mode
