Macro sort/hide function

[UncleBose]

Hello

Just wondering if there's a macro solution to a sort/hide feature I'd like to incorporate.

It's easy enough to sort "have" and "don't have," but once that's done, I'd like to hide all "don't have" rows. The problem is this list is constantly updated, and the number of "don't have" rows is always changing. One day there might be 300 "don't have" rows, and the next day there might be 350.

Also, I'd like another command to restore the list to the original setting (all items sorted and visible) from the hidden mode, so all those "don't have" rows are un-hidden and sorted with the rest.

Using Excel 2007, WinXP. Thanks!

Excel Workbook
A
B
1
item
have
2
peas
yes
3
carrots
yes
4
turnips
yes
5
cabbage
6
pears
yes
7
bananas
8
apples
yes
9
oranges
10
tomatoes
Sheet1
Excel 2007

 

[AlphaFrog]

Have you considered using the AutoFilter feature? This could easily Hide\Unhide your "have" and "don't have".

Excel Filters: Excel 2007 AutoFilter Basics

 

[Datsmart]

I would suggest using Advanced Filtering.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

AdvancedFilter Video Demo here:
http://www.contextures.com/xlVideos04.html

Another good link with sample VBA code here:
http://www.meadinkent.co.uk/xlfilter.htm

Advanced Filter allows you to preset filter options.
It also allows you to filter by criteria in ways standard autofilter can not do. You can choose an export location in the dialog box or in VBA code.
Once you setup the code and criteria, you can use a macro button to copy specific data from your main sheet to a "Report" sheet. The original data remains unchanged and the data "Filtered" to another page can be used as desired.