Solved: Conditional Output to Pre-Formatted Worksheet

[Sisu]

Paul & Rob,

I am speechless . I cannot express my thanks enough for this help and code. I tested Paul's first reply on my 1800 row sheet and it appears to work perfectly as designed. Admittedly, I cannot completely follow the reasoning behind your two recent discussion. Can I remain with Paul's code?

This is also perfect in that it's simple enough that I can keep up with the logic if I cannot at least create it myself. Perhaps in time with practice and study I can follow this excellent example.

There are just two minor issues I can see in the result of this code on the sheet. One is that it does not remove any instance of "unknown" in any cell in the "Groups" column.

The other issue regards email output but my database is not normalized before I can mention anything further. There are more than just two types of emails at the moment (e.g. "email 1"), but this will be fixed when I have access to it next week. But it should not be an issue when cleaned up into either business or personal email types.

A sincere thank you Paul for finding a solution where many others could not.

-Sisu

EDIT: I was posting as Rob put the unknown removal code up. Only the Unknown in the cell needs to be removed, not the whole row. I've done this before with find/replace and formulas but to have everything in one perhaps it's possible in VBA?