software

Hello everybody! I need to know how to compare two worksheets. I do not
know anything about Excel. I need to know how to generate the
differences into a new worksheet. Any help would be appreciated. Thank
you.--
rageon75
------------------------------------------------------------------------
rageon75's Profile: www.excelforum.com/member.php...oamp;userid=31862
View this thread: www.excelforum.com/showthread...hreadid=515903For tasks such as this, I use Jim Cone's fine commercial Add-in called quot;XL
Companionquot;. It will give a complete listing of all the differences between
the two sheets. It's available at www.realezsites.com/bus/primitivesoftware/Vaya con Dios,
Chuck, CABGx3quot;rageon75quot; wrote:

gt;
gt; Hello everybody! I need to know how to compare two worksheets. I do not
gt; know anything about Excel. I need to know how to generate the
gt; differences into a new worksheet. Any help would be appreciated. Thank
gt; you.
gt;
gt;
gt; --
gt; rageon75
gt; ------------------------------------------------------------------------
gt; rageon75's Profile: www.excelforum.com/member.php...oamp;userid=31862
gt; View this thread: www.excelforum.com/showthread...hreadid=515903
gt;
gt;


So there is no function in Excel? I have to buy an add on product to do
this task? By the way thanks for the reply.--
rageon75
------------------------------------------------------------------------
rageon75's Profile: www.excelforum.com/member.php...oamp;userid=31862
View this thread: www.excelforum.com/showthread...hreadid=515903There are combinations of formulas and processes that will allow one to quot;do
it by handquot;, but frankly, I wouldn't bother..........the add-in does it
quickly and I trust the results.........whereas if I did it by hand, I would
have to check and doublecheck.

BTW, you're welcome.........

Vaya con Dios,
Chuck, CABGx3
quot;rageon75quot; wrote:

gt;
gt; So there is no function in Excel? I have to buy an add on product to do
gt; this task? By the way thanks for the reply.
gt;
gt;
gt; --
gt; rageon75
gt; ------------------------------------------------------------------------
gt; rageon75's Profile: www.excelforum.com/member.php...oamp;userid=31862
gt; View this thread: www.excelforum.com/showthread...hreadid=515903
gt;
gt;

rageon75, here is a post by Gord Dibben on the subject and the addin is free

The add-in, Compare.xla written by Myrna Larson and Bill Manville, allows
you to compare the contents of two workbooks and highlight differences.www.cpearson.com/excel/whatsnew.htmLook for Compare.xla.Download Compare.xla and add it with rest of your your add-ins.
On Tools Menu, select add-ins and check in (tick in)Compare Worksheets.
From tools menu then select Compare Sheets and follow instructions.

Gord Dibben Excel MVP - XL97 SR2 amp; XL2002
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;rageon75quot; gt; wrote in
message ...
gt;
gt; Hello everybody! I need to know how to compare two worksheets. I do not
gt; know anything about Excel. I need to know how to generate the
gt; differences into a new worksheet. Any help would be appreciated. Thank
gt; you.
gt;
gt;
gt; --
gt; rageon75
gt; ------------------------------------------------------------------------
gt; rageon75's Profile:
www.excelforum.com/member.php...oamp;userid=31862
gt; View this thread: www.excelforum.com/showthread...hreadid=515903
gt;
I don't know if you just want to eyeball them, or do parity checking cell by
cell - but Try Excel help - compare worksbooks. Thsi is what you get for the
answer:

Open the workbooks you want to compare side by side.

On the Window menu, click Compare Side by Side with.

On the Compare Side by Side toolbar (toolbar: A bar with buttons and options
that you use to carry out commands. To display a toolbar, click Customize on
the Tools menu, and then click the Toolbars tab.), do any of the following:

If you want to scroll through the workbooks at the same time, click
Synchronous Scrolling .

If you want to reset the workbook windows to the positions they were in when
you first started comparing workbooks, click Reset Window Position .

Click Close Side by Side to stop comparing workbooks.

Note If you open two workbooks, the command on the Window menu will include
the filename of one of those workbooks. For example, you open quot;workbook1.xlsquot;
and quot;workbook2.xlsquot;. While viewing quot;workbook1.xlsquot;, the Window menu shows the
command as Compare Side by Side with workbook2.xls.

good luck

quot;rageon75quot; wrote:

gt;
gt; Hello everybody! I need to know how to compare two worksheets. I do not
gt; know anything about Excel. I need to know how to generate the
gt; differences into a new worksheet. Any help would be appreciated. Thank
gt; you.
gt;
gt;
gt; --
gt; rageon75
gt; ------------------------------------------------------------------------
gt; rageon75's Profile: www.excelforum.com/member.php...oamp;userid=31862
gt; View this thread: www.excelforum.com/showthread...hreadid=515903
gt;
gt;