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
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!