Forum Discussion
Show filtered data in one spreadsheet clicking buttons in another
Morning, champions! Two spreadsheets in one workbook. In one spreadsheet I have thousands of rows. I have identified about 350 groupings of these rows and by clicking one of 350 corresponding li...
Hi Dave,
Have you used Power Query at all? You could use that to grab the first full list and then filter by the 2nd Index List (using a merge operation) and output the filtered list to a new sheet.
I can attach a demo file.
What version of Excel are you on Excel 2016?
Have you used Power Query at all? You could use that to grab the first full list and then filter by the 2nd Index List (using a merge operation) and output the filtered list to a new sheet.
I can attach a demo file.
What version of Excel are you on Excel 2016?