I use Autofilter for sorting various quantities, manufacturers, item numbers
etc. The problem I am having is when I pick a category to sort by, from the
autofilter pull-down arrow, and I have rows hidden in my worksheet the hidden
rows reappears when the new category is picked. In other words I am trying
to find a way to keep the hidden rows hidden when sorting by different
categories. Thanks for the help.