Forum Discussion
Excel Lists
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.
I have a construction company. I have a worksheet that lists my 53 projects. Each project/listing on that worksheet has a Project Manager name associated with it. Any one Project Manager may have five or six projects to handle. So as I look through that list of 53 projects, I see the names randomly. I would like to take each of those names/entries and have them also show on another worksheet/"summary" worksheet, thus a worksheet with all Bill's jobs, a worksheet with all Dan's jobs, a worksheet with all of Mike's jobs, etc. I cannot do an = formula to have what is in one cell show up in another, because project locations move within the lines of the worksheet, closed projects go away, new projects are added. Thinking of an IF formula; if a range of cells has the name Mike in it, then the info will show in the cell within the "summary" worksheet. Sorry, does this explain it better?