Sort a list macro.

[Guest]

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.

 

[Guest]

I not an expert, but here is how I would do it.

1. Rearrange the columns so the columns within which you want to sort rows
are adjacent. In your example, if you don't want to sort Col A and Col E,
make them the first two columns. Use Copy and paste to do this.
2. HIghlight the range in the columns that you do want to sort, and do a
row sort on this data. (e.g. DATA, SORT, select sort field, ascending or
decending, etc.)
3. Using copy and paste, put Col E back where it started.

If this produces the results you need, then select Macros, turn on "start
recording macro, enter macro name, hot key, perform the above operations,
stop recording the macro, and you should be able to resort using the macro.

There is probably a more elegant way to do this, but the above should work
for you.

Bill