Filter or Sort??

[Getting Fired]

I have no code to give because I'm a rookie for VB. I figured it out with
excel functions but would like a command button to sort or filter.

I have city, state, date, etc....I'd like click on the command button John
Doe and it sorts out the states given in a range, for a total of 3 people.

My best example:

John = AK, MN, PA - A1:A3
Nick = AL, NM, WY - A4:A6
James = CA, NV, MI - A7:A9

Click on command button - John, sorts or filters these states and deletes
the rest.

Then a undo command button that will bring them all back.

Any help would be great.

Thanks for reading and helping.

 

[royUK]

The best way to get started with this would be to record he process wit
the Macro Recorder. The resulting code will need editing

Give it a try & post back for help editing your code

--
royU

Hope that helps.

RoyU