Forum Discussion
Excel Lists
I am looking to take a worksheet of various names and copy/sort those names to 5 other sheets, i.e. all of the names Bill appear on the same worksheet, all the names Mike, appear on the same workshee...
Attached is a sample workbook. This method uses the FILTER function.
Thank you Patrick. I will have to figure out how to open this. My work firewall filtered it. I can't open it.
Here are two good sources for understanding the FILTER function. So if you can't open Patrick2788 's example, perhaps you could create your own.
https://exceljet.net/excel-functions/excel-filter-function
https://www.youtube.com/watch?v=9I9DtFOVPIg
