Excel for Mac 2011 user here.
I have a large amount of data - about 3,000 rows - in the first tab of a workbook. The data is not setup in a table and I cannot change the formatting.
I want the second tab to be able to filter the data from the first tab based on multiple criteria (up to 3) as selected by the user, as well as date range criteria.
I've attached a sample file that provides further details and explanation. I'm open to VBA, formulas, or going in a completely different direction if there are any other suggestions of how best to approach this. In Excel for Mac 2011 I cannot use ActiveX controls though. I'm still learning it myself (used to Excel for PC) so there could be other limitations too that I'm just not familiar with yet.
Thanks in advance for your thoughts!
I have a large amount of data - about 3,000 rows - in the first tab of a workbook. The data is not setup in a table and I cannot change the formatting.
I want the second tab to be able to filter the data from the first tab based on multiple criteria (up to 3) as selected by the user, as well as date range criteria.
I've attached a sample file that provides further details and explanation. I'm open to VBA, formulas, or going in a completely different direction if there are any other suggestions of how best to approach this. In Excel for Mac 2011 I cannot use ActiveX controls though. I'm still learning it myself (used to Excel for PC) so there could be other limitations too that I'm just not familiar with yet.
Thanks in advance for your thoughts!