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...
The "this" that you are wanting help to accomplish is not at all clear. Why don't you start with a far more clear description of the raw data and the desired outcome.
What's the purpose of the sort to the 5 different sheets in the first place? It's not clear, for example, whether you WANT all of the names of "Bill" to appear on the sam worksheet or if that's what you're hoping to overcome.