Search for text and list in separate tabs based on result

I'm looking to sort a pile of data based on what names appear in a comments cell, into separate tabs sorted by the name contained. There is also a separate tab for items with no name included.

So all of the listings containing Andy appear in Andy's tab, all of Billy's appear in his tab and so on. Listings with no name go into a separate tab.

Hope this picture explains it. I attempted to upload a sample, but it wasn't working.

Capture.JPG

Thanks

Sample.xlsx

complete:
Sample.xlsx

Please Login or Register  to view this content.

that's perfect, thanks!

How would I go about scaling it up to include surnames, and add more names?

It's up to you.
The code is looking at the sheet names for the the criteria of Autofilter, so if you add more worksheets with the names that you want to retrieve, it will do the job.

And if you change worksheet names to full name, it also filter with the full name.

And if I have a longer list of data, will it work?

It should.

Jut try it for yourself and if you find any problem post back.

I've changed to full names and got the error:

Ambiguous name detected: test

That means you have multiple procedure named "test" within a same module.

Delete one of them or rename it to something else like "test2"...

Thanks for all your help with this.

I've tried pasting in the real data, and I'm finding that not all of the data is being filtered into the pages.

out of 245 entries, only 153 of them are appearing in any of the sheets.

Is there anything that would cause certain cells to be ignored

Do you mean the rows that should be allocated to certain worksheet appears to "No name" sheet?

If so, the sheet name and the name in the comment are not matching.
Check the sheet name like extra space, otherwise I need to see your workbook.

It's missing data.

I pasted the data in two separate blocks. It seems like the first block is working, but the second block isn't.

Some data with names hasn't been filtered into the relevant sheets, some with no names haven't been filtered either.

It isn't isolated to specific names, as one name which should have 9 entries only has 5.

All 9 appear in the data tab, 5 appear in that person's tab, and none of the remaining 4 entries appear in either that person's tab or the no name tab.

Originally Posted by anglarna_ger

I pasted the data in two separate blocks. It seems like the first block is working, but the second block isn't.

I don't understand this meaning.

How do you exactly have data layouts?