Set up your sheet as described, making sure your top row is a header of
column descriptors and that you have no blank columns or rows in your
grid. Place your cursor in the top left cell (A1?) and from the main
menu, choose DataFilterAutoFilter
There will appear dropdown arrows in each header cell. Click the one
in col. G and choose Sort Ascending.
Done!
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=526213