software

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

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

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

quot;Barb Reinhardtquot; wrote:

gt; Are you saying you have two workbooks, or are the tables within one
gt; workbook?
gt;
gt; quot;jayceejayquot; gt; wrote in message
gt; ...
gt; gt;I have two workbook tables (Two different workbooks) with two matching
gt; gt;column
gt; gt; names. What I wish to do is to merge values from one table to another,
gt; gt; but
gt; gt; ONLY for those records inwhich these two columns have matching values.
gt; gt; Would
gt; gt; this be possible?
gt; gt;
gt; gt; Jay
gt;
gt;
gt;

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

Pretty please?

quot;jayceejayquot; wrote:

gt; They are in separate workbooks.
gt;
gt; quot;Barb Reinhardtquot; wrote:
gt;
gt; gt; Are you saying you have two workbooks, or are the tables within one
gt; gt; workbook?
gt; gt;
gt; gt; quot;jayceejayquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have two workbook tables (Two different workbooks) with two matching
gt; gt; gt;column
gt; gt; gt; names. What I wish to do is to merge values from one table to another,
gt; gt; gt; but
gt; gt; gt; ONLY for those records inwhich these two columns have matching values.
gt; gt; gt; Would
gt; gt; gt; this be possible?
gt; gt; gt;
gt; gt; gt; Jay
gt; gt;
gt; gt;
gt; gt;

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 quot;Namesquot;
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
Insertgt;Namegt;Define
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
Datagt;Consolidate
Function: Count
Use Labels in:
--gt;Check: Top Row
--gt;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-Proquot;jayceejayquot; wrote:

gt; I never did get much of an answer. Is there no one who could shed some light
gt; on this?
gt;
gt; Pretty please?
gt;
gt; quot;jayceejayquot; wrote:
gt;
gt; gt; They are in separate workbooks.
gt; gt;
gt; gt; quot;Barb Reinhardtquot; wrote:
gt; gt;
gt; gt; gt; Are you saying you have two workbooks, or are the tables within one
gt; gt; gt; workbook?
gt; gt; gt;
gt; gt; gt; quot;jayceejayquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I have two workbook tables (Two different workbooks) with two matching
gt; gt; gt; gt;column
gt; gt; gt; gt; names. What I wish to do is to merge values from one table to another,
gt; gt; gt; gt; but
gt; gt; gt; gt; ONLY for those records inwhich these two columns have matching values.
gt; gt; gt; gt; Would
gt; gt; gt; gt; this be possible?
gt; gt; gt; gt;
gt; gt; gt; gt; Jay
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

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

quot;Ron Coderrequot; wrote:

gt; If this example describes your situation....
gt;
gt; You have 2 workbooks: Book1 and Book2.
gt; Each workbook contains a sheet, ListSheet, with a list of names.
gt; You want to create a 3rd list which only contains the names common to boths
gt; lists that are in Book1 and Book2.
gt;
gt; -------------------------------
gt; Then, you could try this:
gt;
gt; Assumptions:
gt; 1)Each list has a heading, I'll assume quot;Namesquot;
gt; 2)Each list starts in Cell A1 of the ListSheet
gt; 3)Each list has 10 names
gt;
gt; The method:
gt; For each list in Book1 and Book2,
gt; B1: Num
gt; B2:B11 (Enter a zero in of those cells)
gt;
gt; Select A1:B11
gt; Insertgt;Namegt;Define
gt; Names in Workbook: NameList
gt; Refers to: (already selected)
gt; Click the [OK] button
gt; Save each workbook
gt;
gt; Next:
gt; Open a new workbook
gt; Select cell A1 on any sheet
gt; Datagt;Consolidate
gt; Function: Count
gt; Use Labels in:
gt; --gt;Check: Top Row
gt; --gt;Check: Left Column
gt; Browse to Book1.xls.
gt; Reference : (will display the path to the workbook...Append NameList to that
gt; path)
gt; Click the [Add] button
gt; Repeat for Book2.xls
gt; Uncheck: Create Links to source data
gt; Click the [OK] button
gt;
gt; Excel will create a list of all names used in either list along with the
gt; count of those names.
gt; Names with a count of 2 are in both lists.
gt;
gt; Something you could use?
gt;
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;jayceejayquot; wrote:
gt;
gt; gt; I never did get much of an answer. Is there no one who could shed some light
gt; gt; on this?
gt; gt;
gt; gt; Pretty please?
gt; gt;
gt; gt; quot;jayceejayquot; wrote:
gt; gt;
gt; gt; gt; They are in separate workbooks.
gt; gt; gt;
gt; gt; gt; quot;Barb Reinhardtquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Are you saying you have two workbooks, or are the tables within one
gt; gt; gt; gt; workbook?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;jayceejayquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I have two workbook tables (Two different workbooks) with two matching
gt; gt; gt; gt; gt;column
gt; gt; gt; gt; gt; names. What I wish to do is to merge values from one table to another,
gt; gt; gt; gt; gt; but
gt; gt; gt; gt; gt; ONLY for those records inwhich these two columns have matching values.
gt; gt; gt; gt; gt; Would
gt; gt; gt; gt; gt; this be possible?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Jay
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;