Hi,
I have three tabs on one worksheet Tab 1 'Rooster', Tab 2 'Paid' and Tab 3 'Unpaid'. The Rooster Tab 1 has colume A 'parent first name' and in colume B 'parent last name'. On Paid Tab 2 it has colume A 'parent first name' and in colume B is has 'parent last name'.
What I need is Tab 3 Unpaid to have parent names that have not paid. I also need columes C, D, E, F, G and H from Tab 1 Rooster

Rooster
A.........................B.............C......... D.......E......F......G.........H

Candice...........Davis.........1029.....345....45 6...tom.. Sam....4325
Russell............Gomez........f567......543...23 4...dom...was....6543
Carla...............Hyde..........sder........34.. .765....ken...qaq.....9834
Abner..............Blume........9876......123...94 6...mam..you....5408


Paid
A..........................B

Candice............Davis
Carla................Hyde



Unpaid
A.........................B.............C......... D.......E......F.......G.......H

Russell............Gomez........f567......543...23 4...dom...was....6543
Abner..............Blume........9876......123...94 6...mam..you....5408


Thank you,
Ariano

How do you differentiate between those that have paid and those which have not?

You have the Rooster TAB that has all the names. Then you have the Paid TAB that has those that have Paid. By compairing the two Tabs columes A and B, I would need those that have not Paid in the Unpaid Tab.
I hope this helps.
Thanks