software

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.

ThanksThe 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--gt;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?quot;quot; wrote:

gt; Hi, Is it possible to combine two work sheets into one?
gt;
gt; ex: I have first.xls, second.xls
gt;
gt; firsr.xls has columns aa,bb,cc
gt; second.xls has columns aa,bb,cc,dd
gt;
gt; Both sheets has different data. I want to see them in a single sheet at
gt; once side by side and should be able to compare.
gt;
gt; appreciate your help.
gt;
gt; Thanks
gt;
gt;