Need code to populate results based on certain criteria

I don't know if this is the correct forum, whether this can be achieved simply by formulas or not, but I figured here was a good place to start.

I'll provide a template.

This is what I'm looking to accomplish:

This is a spreadsheet that shows which clients are or are not coming to an event that we are putting on. There are a variety of tabs, each for a designated person to keep track of their client contacts and the status of whether or not they were invited, not invited, confirmed that they're coming, or confirmed that they are not coming.

What I'm having issues with is determining a way to show on the first "summary" tab the list of all clients who have confirmed. The idea is for anyone to be able to open up the file and look at the summary tab and be able to see exactly who is attending the event.

Any help is appreciated!!

Anthony

Hiya, I think something like this may work for you (see attachment)

+The code--

Please Login or Register  to view this content.

Poizhan,

Thanks so much for putting this together. It's perfect.

I do have a question, though. How could I incorporate into the code something that dictates only clients that are labeled "Confirmed Yes" populate on the summary tab? As it currently is coded, anyone simply listed in the tables populates on the summary tab.

I'll add data validation so that the RMs can only choose between a few notations.

Thanks again!

Anthony

Also, Poizhan, any time I make any changes to the code, I keep getting an error stating: "Run-time error '1004': Application-defined or objected-defined error" with this portion highlighted: " If ws1.Cells(nRow, "B").Value = ws.Name Then." Is this code unable to be edited?

Poizhan - Additionally, any time I make any subtle change, such as changing RM to the actual person's name, the whole thing just stops working. I see in the code it's "If ws.Name Like "*RM*" Then", so I would put, for example, RM - Person's Name, and the macro just stops working.