Sort a list macro.

[John]

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
can’t 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.

[John]

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
> can’t 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.

[John]

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
> can’t 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.