Filter Excel Table Without Referencing Table Name

Hi --

I have a file with a large amount of sheets and many of the sheets are virtually identical, and include a single Excel Table.
I want to add a button to each of these 'identical' sheets to filter out the "--" values in the 'Tbl_x[Group]' column.
Is it possible to add a single button to each sheet (all referencing a single code) that filters out this value in the "Group" column in the Active Sheet's Excel Table?
Thank you!

-k

Thank you, I'll try this

Is there a way to check if there are more than 1 list objects in a sheet?

Your tbl is set as ws.ListObjects(1), but I'm worried I'll get an error if Excel ever registers a table 'ListObjects(2)' in a sheet.

Thanks!

I do yes --

The main tables all begin with the same 14 characters: 'Table_Account_xxxxxxx'
Beyond those first 14 characters, the rest of the table names can vary greatly w/o consistency.

If any sheet were to have more than one table (which is unlikely), it's safe to say it wouldn't follow the same convention.
So checking for these first characters should suffice when filtering on the 'Group' column in the main tables.

Thank you

Hi!

This code seems to sort the data.
Is there a way to modify so that the it instead filters out the "--" values?
Thank you!