Combo Box To Filter a List of Data

I use Excel 2000.

I want to add a Combo Box that will filter my datasheet for the item selected from the Combo Box. I would also like to be able to return to the complete datasheet in its original order.

In addition, I want to add other Combo Boxes to this datasheet that will further filter the already filtered data of this datasheet. I, therefore, want to not only use just 1 filter, but have the capability to have multi-filtering depending upon what combo Boxes I chose.

I am producing a very important spreadsheet for use with the current pandemic. Time is of the essence to be able to accomplish what I want ASAP.

BTW: Every column will be displayed. Only the the number of rows will be reduced.

Thanks in advance,

Dan

Thanks AlphaFrog.

That is the way I would do. However, the end user is not an Excel user. I am trying to incorporate simple buttons for the end user.

Dan