Can I do this. I want to select only Smith. I want patients who do not have a billing code of Z00.00 or Z00.129. the data is across 6 sheets. I want to export only Smith.
Name Pat# Bill code
Jones 123 F34
Jones 123 H01
Jones 123 Z00.00
Jones 123 090
Name Pat# Bill code
Smith 456 F34
Smith 456 H01
Smith 456 J87
Smith 456 090
Name Pat# Bill code
Jones 123 F34
Jones 123 H01
Jones 123 Z00.00
Jones 123 090
Name Pat# Bill code
Smith 456 F34
Smith 456 H01
Smith 456 J87
Smith 456 090
