Hi,

I'm trying to export a list of everything associated to someones name. I have a sheet with all the raw data with many names and things associated but I want to see everything that has just "x" name without filtering. And then taking everything that's associated with "x" and seeing that on another sheet.

To explain a bit more, I have 1 blank sheet. They select their name from a drop down list and being able to see everything that's related to their name.

Using formula to try and present it neatly. Is this possible?