Taking Tab information

M

maxebi

Hi,
I have three tabs on one worksheet Tab 1 'Rooster', Tab 2 'Paid' and Ta
3 'Unpaid'. The Rooster Tab 1 has colume A 'parent first name' and i
colume B 'parent last name'. On Paid Tab 2 it has colume A 'parent firs
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.
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....456...tom.. Sam....4325
Russell............Gomez........f567......543...234...dom...was....6543
Carla...............Hyde..........sder........34...765....ken...qaq.....9834
Abner..............Blume........9876......123...946...mam..you....5408


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

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



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

Russell............Gomez........f567......543...234...dom...was....6543
Abner..............Blume........9876......123...946...mam..you....5408


Thank you,
Arian
 
M

maxebi

Spencer101;1605686 said:
How do you differentiate between those that have paid and those whic
have not?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top