Thanks for the info.

I already knew how to do this. What I am trying to do is compare to column
from to different worksheets extract that info and then compare the rows from
the two diferent worksheets.

"challa prabhu" wrote:

Hi,

Your subject line says compare Excel Workbook, but the information in the
message box is about two worksheets. Is it worksheets in different workbook
or worksheets in a workbook.

If its comparing workbook, then

Compare workbooks side by side

1. Open the workbooks you want to compare side by side.
2. On the Window menu, click Compare Side by Side with.
3. On the Compare Side by Side toolbar 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 .

4. 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.

Important: If it is comparing betwen two worksheets in a workbook, then use
Autofilter on each worksheet.


Challa Prabhu



"willirwin" wrote:

I have to worksheets the have of 3000 entries and I need to compare it to
another worksheet that has over 12000 and I need to find the same infor on
both is there a way to sort this out.