Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 7th 06, 10:01 PM posted to microsoft.public.excel.newusers
jayceejay
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

I have two workbook tables (Two different workbooks) with two matching column
names. What I wish to do is to merge values from one table to another, but
ONLY for those records inwhich these two columns have matching values. Would
this be possible?

Jay

  #2   Report Post  
Old January 7th 06, 11:55 PM posted to microsoft.public.excel.newusers
Barb Reinhardt
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

Are you saying you have two workbooks, or are the tables within one
workbook?

"jayceejay" wrote in message
...
I have two workbook tables (Two different workbooks) with two matching
column
names. What I wish to do is to merge values from one table to another,
but
ONLY for those records inwhich these two columns have matching values.
Would
this be possible?

Jay



  #3   Report Post  
Old January 8th 06, 12:09 AM posted to microsoft.public.excel.newusers
jayceejay
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

They are in separate workbooks.

"Barb Reinhardt" wrote:

Are you saying you have two workbooks, or are the tables within one
workbook?

"jayceejay" wrote in message
...
I have two workbook tables (Two different workbooks) with two matching
column
names. What I wish to do is to merge values from one table to another,
but
ONLY for those records inwhich these two columns have matching values.
Would
this be possible?

Jay




  #4   Report Post  
Old January 8th 06, 08:49 PM posted to microsoft.public.excel.newusers
jayceejay
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

I never did get much of an answer. Is there no one who could shed some light
on this?

Pretty please?

"jayceejay" wrote:

They are in separate workbooks.

"Barb Reinhardt" wrote:

Are you saying you have two workbooks, or are the tables within one
workbook?

"jayceejay" wrote in message
...
I have two workbook tables (Two different workbooks) with two matching
column
names. What I wish to do is to merge values from one table to another,
but
ONLY for those records inwhich these two columns have matching values.
Would
this be possible?

Jay




  #5   Report Post  
Old January 8th 06, 09:32 PM posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

If this example describes your situation....

You have 2 workbooks: Book1 and Book2.
Each workbook contains a sheet, ListSheet, with a list of names.
You want to create a 3rd list which only contains the names common to boths
lists that are in Book1 and Book2.

-------------------------------
Then, you could try this:

Assumptions:
1)Each list has a heading, I'll assume "Names"
2)Each list starts in Cell A1 of the ListSheet
3)Each list has 10 names

The method:
For each list in Book1 and Book2,
B1: Num
B2:B11 (Enter a zero in of those cells)

Select A1:B11
InsertNameDefine
Names in Workbook: NameList
Refers to: (already selected)
Click the [OK] button
Save each workbook

Next:
Open a new workbook
Select cell A1 on any sheet
DataConsolidate
Function: Count
Use Labels in:
--Check: Top Row
--Check: Left Column
Browse to Book1.xls.
Reference : (will display the path to the workbook...Append NameList to that
path)
Click the [Add] button
Repeat for Book2.xls
Uncheck: Create Links to source data
Click the [OK] button

Excel will create a list of all names used in either list along with the
count of those names.
Names with a count of 2 are in both lists.

Something you could use?


***********
Regards,
Ron

XL2002, WinXP-Pro


"jayceejay" wrote:

I never did get much of an answer. Is there no one who could shed some light
on this?

Pretty please?

"jayceejay" wrote:

They are in separate workbooks.

"Barb Reinhardt" wrote:

Are you saying you have two workbooks, or are the tables within one
workbook?

"jayceejay" wrote in message
...
I have two workbook tables (Two different workbooks) with two matching
column
names. What I wish to do is to merge values from one table to another,
but
ONLY for those records inwhich these two columns have matching values.
Would
this be possible?

Jay





  #6   Report Post  
Old January 8th 06, 11:28 PM posted to microsoft.public.excel.newusers
jayceejay
 
Posts: n/a
Default Merging Workbook Table data Based upon Value comparisons

Ron:

Thank you so much for your efforts. This isn't PRECISELY what I had in mind
but it is close enough for me to fashion a solution. I APPRECIATE what you
have done for me!

Jay

"Ron Coderre" wrote:

If this example describes your situation....

You have 2 workbooks: Book1 and Book2.
Each workbook contains a sheet, ListSheet, with a list of names.
You want to create a 3rd list which only contains the names common to boths
lists that are in Book1 and Book2.

-------------------------------
Then, you could try this:

Assumptions:
1)Each list has a heading, I'll assume "Names"
2)Each list starts in Cell A1 of the ListSheet
3)Each list has 10 names

The method:
For each list in Book1 and Book2,
B1: Num
B2:B11 (Enter a zero in of those cells)

Select A1:B11
InsertNameDefine
Names in Workbook: NameList
Refers to: (already selected)
Click the [OK] button
Save each workbook

Next:
Open a new workbook
Select cell A1 on any sheet
DataConsolidate
Function: Count
Use Labels in:
--Check: Top Row
--Check: Left Column
Browse to Book1.xls.
Reference : (will display the path to the workbook...Append NameList to that
path)
Click the [Add] button
Repeat for Book2.xls
Uncheck: Create Links to source data
Click the [OK] button

Excel will create a list of all names used in either list along with the
count of those names.
Names with a count of 2 are in both lists.

Something you could use?


***********
Regards,
Ron

XL2002, WinXP-Pro


"jayceejay" wrote:

I never did get much of an answer. Is there no one who could shed some light
on this?

Pretty please?

"jayceejay" wrote:

They are in separate workbooks.

"Barb Reinhardt" wrote:

Are you saying you have two workbooks, or are the tables within one
workbook?

"jayceejay" wrote in message
...
I have two workbook tables (Two different workbooks) with two matching
column
names. What I wish to do is to merge values from one table to another,
but
ONLY for those records inwhich these two columns have matching values.
Would
this be possible?

Jay





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
Auto updating a workbook with data from another workbook Richard Excel Discussion (Misc queries) 0 November 6th 05 03:50 PM
Sharing data across worksheets within a workbook based on identifi deedle93 Excel Discussion (Misc queries) 2 August 18th 05 04:26 AM
Another Exciting Data Table Question!!!! xinekite Charts and Charting in Excel 1 May 29th 05 01:22 PM
Getting data from another workbook based on variable joemc911 Excel Discussion (Misc queries) 3 May 25th 05 09:18 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM


All times are GMT +1. The time now is 08:11 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017