If value = FALSE, information is populated on separate tab

I have a report of prospective clients and whether they started services. If a client did not start services, I want the contact's name, the name of the salesperson responsible for that contact, and the planned start date to be listed on a separate tab.

I've attached a spreadsheet with fake data on the first sheet and the desired output on the second sheet.

I tried using a formula on the second sheet (=IF('Sheet1'!L2=FALSE,'Sheet1'!E2," ")) to give me a list of the names, but I don't want the blank entries for the TRUE results to be on Sheet2--only those that are false.

What is the best way to write this macro? Any suggestions are appreciated!

Hi Micina,

Or with a Pivot Table - please see attached. It would look better with a longer list if you have one ?
Will this work for you?

Regards

peterrc

Smart, peterrc! Thanks for the suggestion--it does exactly what I want it to!

Hi micina,

Happy to help!
If your query has been resolved please remember to mark your post SOLVED.
Thanks

Regards

peterrc