Create unique list from a column display the results in a drop down using the Ribbon bar display the filter on the worksheet

Refresh

2 weeks ago

Views

19 time

0

I have 29,000 plus rows on a sheet called DataCalcs. In column AG I have values like the following:

Altern 1
Altern 1
Altern 1
Altern 1
Altern 1
Altern 1
Base   2
Base   2
Base   2
Base   2
Base   2

and so on in column AG

I need code that will filter this data and display what is filtered from a custom Menu I have created on the Excel Ribbon.

I also need the data to be displayed on the DataCalcs worksheet when the menu on the drop down from the Ribbon Bar is selected based on the unique selections in column AGthat are filtered.

I also have saved this data in a range called DataCalcs so please feel free to use that named range in the code.

Thanks for looking and reading!

0 answers