Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Data
No one knows how to do this? Maybe I need to clarify more? Or is this
impossible? : - ( "LoriH" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining data | Excel Worksheet Functions | |||
Combining Data | Excel Discussion (Misc queries) | |||
Combining data | Excel Discussion (Misc queries) | |||
combining multiple rows of data into one single row of data | Excel Worksheet Functions | |||
Combining Data | Excel Discussion (Misc queries) |