simple macro

[patsyreyes]

Here's what my database will look like:

GEE-xxx 1109-xxx-11MRT100 181370034 7/13/11
GEE-xxx 1109-xxx-11MRT100 181370035 7/13/11
GEC-xxx 2003-xxx-11MMT300 181454517 7/13/11
GEC-xxx 2003-xxx-11MMT300 181398714 7/13/11
GEL-xxx 2003-xxx-11MLT300 181305479 7/14/11
GEE-xxx 2003-xxx-11MLT300 181415880 7/14/11
GEL-xxx 2003-xxx-11MLT300 181451720 7/14/11

What I need is a macro that will return all those beginning with GEE in the first column.

 

[Andrew Poulsom]

Can't you just use AutoFilter?

 

[patsyreyes]

Yes, but the database is not for my use solely. Others are not so savy in excel. A quick macro button is the easiest.