Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 19th 12, 11:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 2
Default Taking Tab information

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

  #2   Report Post  
Old September 20th 12, 08:22 AM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by maxebi View Post
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?
  #3   Report Post  
Old September 20th 12, 05:30 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 2
Default

Quote:
Originally Posted by Spencer101 View Post
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Taking relevant information to sheet 2 Sir Paul Excel Worksheet Functions 1 June 30th 11 03:04 PM
information on taking advantage of XL 07 & multi-core processors Dave F Excel Discussion (Misc queries) 2 January 8th 07 08:21 PM
Sorting a Column and taking row information with it. Michaela Excel Worksheet Functions 2 November 20th 06 10:54 AM
Taking multiple information from one cell. Carrguy[_2_] Excel Programming 1 July 5th 06 04:39 PM
Taking information out of excel and making a table of responses in stanger help Excel Programming 0 December 21st 05 02:12 AM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017