Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

combining two woeksheets into one

0 views
Skip to first unread message

krall...@gmail.com

unread,
Jan 9, 2006, 11:48:07 AM1/9/06
to
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

Jonathan Cooper

unread,
Jan 9, 2006, 12:11:06 PM1/9/06
to
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?"

0 new messages