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.

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

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


--
royUK

Hope that helps.

RoyUK
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26890