consolidate data

K

kim

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
 
R

Roger Govier

Hi Kim

On Sheet1, mark column B>right click>Insert
In B1 enter
=Sheet2!B1 and copy down as required
in D1 enter
=Sheet2!C1 and copy down
 

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

consolidate info 0
Need formula creation 1
slecting averages from a changing table 0
Vlook match 2
data matchin 1
Creating a function 3
Vlookup? 1
Need help with this "StringConcat" formula 1

Top