Combining Data

L

LoriH

I have two separate files with similar but different data and I need to
combine them to a third. Since I need to make sure the Datat in collum A and
B of the two work books match to retunr the answer in workbook 3, I can't
wrap my head around how to do this. I put examples of the data below to make
this easier to understand. Help?

WorkBook 1
Account # Product 08 YTD Aug 08 TOTALS
Jane AAA 200 300
Jane BBB 3235 4852
Jane CCC 1215 1822
Dan FFF 212 318
Dan GGG 565 847
Dan HHH 700 1050
Bob CCC 779 1168
Bob EEE 100 150

WorkBook 2
Account # Product 06 YTD Aug 06 TOTALS 07 YTD Aug 07 TOTALS
Jane BBB 2356 3534 895 1342
Jane CCC 986 1479 1154 1731
Jane DDD 458 687 635 952
Dan DDD 659 988 657 985
Dan EEE 655 982 545 817
Dan FFF 889 1333 569 853
Bob BBB 2225 3337 235 352
Bob CCC 1142 1713 135 202
Bob FFF 985 1477 965 1447

Worksheet 3
Account # Product (All collumns with Data on worksheet 1 and 2 would
follow)
Jane AAA
Jane BBB
Jane CCC
Jane DDD
Jane EEE
Jane FFF
Jane GGG
Jane HHH
Dan AAA
Dan BBB
Dan CCC
Dan DDD
Dan EEE
Dan FFF
Dan GGG
Dan HHH
Bob AAA
Bob BBB
Bob CCC
Bob DDD
Bob EEE
Bob FFF
Bob GGG
Bob HHH
 
L

LoriH

No one knows how to do this? Maybe I need to clarify more? Or is this
impossible? : - (
 

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

Similar Threads

Extract data in rows (with line breaks) to form a table 0
macro to stack/transpose select rows (cpm) 0
Matching data 0
row comparison 5
Compare 2 lists / conduct gap analysis (XL 2007) 5
Compare cells in different worksheets 3
Rearranging columns/rows 1
Group/Sort records in Excel 3

Top