Originally Posted by maxebi

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