No that doesn't work, as I first filter Names on a worksheet to get my results - I then want to take those results and use them to filter out everything else from asset names and leave me just the results from Names.
Have you got a sample workbook with dummy data? Providing this to us can let us help you faster.
Appreciate you time here.
What I'd like to do is, only display the names mentioned on Worksheet 1 on Worksheet 2 - filter in other words.
I'm aware I could just drag Name from Worksheet 1 next to Asset Name on Worksheet 2 perform the filter on Worksheet 2, however this will later cause me issues with the infamous ' * ' appearing.
So I'm looking at another way to do this ?
filter_by_sheet.twbx 82.8 KB