I have a workbook with 3 columns of data- item number, description and
vendor. There are drop down menus at the top of each column, so a user can
choose, for example, to look at items from only a certain vendor. In
addition, each branch does a 'format, row, hide' on certain rows to hide that
data, since they do not use that item in their branch.

If a user has hidden any rows of data, then they choose a vendor from the
drop down box, then choose 'All' from the drop down box to return the sheet
to its original form, at that point, ALL the rows appear, even the ones that
were hidden, and the sheet then saved. I do not want the hidden rows to
reappear, how do I do that? Thank you.