View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Brainless_in_Boston
 
Posts: n/a
Default Compare two worksheets

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 "workbook1.xls"
and "workbook2.xls". While viewing "workbook1.xls", the Window menu shows the
command as Compare Side by Side with workbook2.xls.

good luck

"rageon75" wrote:


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: http://www.excelforum.com/member.php...o&userid=31862
View this thread: http://www.excelforum.com/showthread...hreadid=515903