combining two woeksheets into one

[krallabandi]

Hi, Is it possible to combine two work sheets into one?

ex: I have first.xls, second.xls

firsr.xls has columns aa,bb,cc
second.xls has columns aa,bb,cc,dd

Both sheets has different data. I want to see them in a single sheet at
once side by side and should be able to compare.

appreciate your help.

Thanks

 

[Guest]

The easiest thing to do, is to copy/paste from second.xls into ff, gg, hh.

Or....

if you have Excel 2003, you can go to Window-->compare side by side with

or....

Use helper columns to do the comparison for you.

In first.xls go to column ff. Use the following formula

=EXACT(AA1,[second]Sheet1!AA1)

This will give you a true or false answer to the question, 'Do these cells
match exactly?"