Table Filter/ Reset Button Needed

[Rhall6310]

I have a table comprised of an inventory 4,207 individual commercial furniture line items.

Line Item Example:
Type of Furniture Manufacturer Model/Style Size Finish Condition Building Location Code Future Location Bar Code
Task Chairs Allsteel Task Mesh Back / Dark Red Poor Main main1st1 4207

It is being used to assist in inventory searches across three buildings and hundreds of rooms within the buildings.

I am using the Filter and Sort option supported in the header info of the table.

For Example when I want to find all the Task Chairs made by Allsteel in the main building - I adjust the filters and get the report I need. Very clean and simple.

WHAT I NEED - is a reset button that puts all the filter criteria back into "Select All" mode so we do not have to manually go back a reset every filter option we selected to the Select All positionAttachment 362621.

Is there a way to accomplish this?

Any help is appreciated - we have just started to use this table of inventory and people are not resetting the filters and getting bad reports.
Would be happy to forward the table.
Thanks Rhall

[Blake 7]

Assign this macro to a button - dobt forget to change the table name to the name of your table

ActiveSheet.ListObjects("Table1").Range.AutoFilter

actually, that removes the filters - this one resets them

Please Login or Register  to view this content.

[Rhall6310]

Blake - Thanks a ton - works perfectly!

[Blake 7]

glad to help dude - usually i'm asking for help so it's nice to give something back.