Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a list macro.
Sorry reposting because of tabs format.
Hi, I am creating a sheet that will list who can buy bus passes. Here is the lay out. A4 B4 C4 D4 E4 F4 G4 H4 # Last name First Name NB # Last name First Name NB 1 4 2 5 3 6 I believe I need a macro to sort by Last Name. Now rows under A4 and E4 cant change. They will hold the numbers of how many people have been approved. As you can see it will have two columns of names per page. It will have 88 names per page, three pages for a total of 264 names. We are a non-profit organization. We help homeless and low-income people. These discount bus pass are sold to qualify people and we make no money from the sales. Those I know how to use excel my skill level is not up for this. Any help you can give will be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a list macro.
Sorry the way this site format.
A4 B4 C4 D4 E4 F4 G4 H4 # Last Name First Name NB # Last Name First Name NB 1 5 2 6 3 7 4 8 "John" wrote: Sorry reposting because of tabs format. Hi, I am creating a sheet that will list who can buy bus passes. Here is the lay out. A4 B4 C4 D4 E4 F4 G4 H4 # Last name First Name NB # Last name First Name NB 1 4 2 5 3 6 I believe I need a macro to sort by Last Name. Now rows under A4 and E4 cant change. They will hold the numbers of how many people have been approved. As you can see it will have two columns of names per page. It will have 88 names per page, three pages for a total of 264 names. We are a non-profit organization. We help homeless and low-income people. These discount bus pass are sold to qualify people and we make no money from the sales. Those I know how to use excel my skill level is not up for this. Any help you can give will be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort a list macro.
Sorry again
A4 = # B4 = Last name C4 = First Name D4 = NB E4 = # F4 = Last name G4 = First Name H4 = NB "John" wrote: Sorry reposting because of tabs format. Hi, I am creating a sheet that will list who can buy bus passes. Here is the lay out. A4 B4 C4 D4 E4 F4 G4 H4 # Last name First Name NB # Last name First Name NB 1 4 2 5 3 6 I believe I need a macro to sort by Last Name. Now rows under A4 and E4 cant change. They will hold the numbers of how many people have been approved. As you can see it will have two columns of names per page. It will have 88 names per page, three pages for a total of 264 names. We are a non-profit organization. We help homeless and low-income people. These discount bus pass are sold to qualify people and we make no money from the sales. Those I know how to use excel my skill level is not up for this. Any help you can give will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort a list macro. | Excel Discussion (Misc queries) | |||
How to force a Default sort for a validation list | Excel Discussion (Misc queries) | |||
Randomly Generated List / Macro | Excel Worksheet Functions | |||
delete a macro that isn't in macro list | Excel Discussion (Misc queries) | |||
Sort Macro: Utilizing ComboBox Selection for Key1 through 3 Ranges | Excel Discussion (Misc queries) |