consolidate data
 

I have 2 seperate workbook each workbook contains certain numbers and $
amount. Here is how I want to result:

before consolidate:
workbook #1 Workbook#2
colum A Colum B Colum C Colum A Colum B
Colum C
1235 $50 $25 1235 $65
$20
7858 $75 $31 7858 $75
$31
2538 $40 $46 2538 $41
$74

After consolidated:
under workbook #1
colum A colum B Colum C(show data from colum B under workbook#2 )
1235 $50 $65
7858 $75 $75
2538 $40 $41

and colum C from workbook#1 may show in colum D and colum C from workbook #2
may show in colum E in workbook after consolidated.

How do I do this??
thank you

consolidate data
 

Hi Kim

On Sheet1, mark column Bright clickInsert
In B1 enter
=Sheet2!B1 and copy down as required
in D1 enter
=Sheet2!C1 and copy down

--
Regards
Roger Govier



"kim" wrote in message
...
I have 2 seperate workbook each workbook contains certain numbers and $
amount. Here is how I want to result:

before consolidate:
workbook #1 Workbook#2
colum A Colum B Colum C Colum A Colum B
Colum C
1235 $50 $25 1235 $65
$20
7858 $75 $31 7858 $75
$31
2538 $40 $46 2538 $41
$74

After consolidated:
under workbook #1
colum A colum B Colum C(show data from colum B under
workbook#2 )
1235 $50 $65
7858 $75 $75
2538 $40 $41

and colum C from workbook#1 may show in colum D and colum C from workbook
#2
may show in colum E in workbook after consolidated.

How do I do this??
thank you