I have 2 seperate workbooks, 3 sheets each. However only the first shee
is being utilized.

I want to compare the first sheet of both workbooks and fin
discrepancies... The number of records will change every time in bot
workbooks as the sheets are pulled of a programme, also the number o
records in both workbooks might be equal and then again it may not be.

The columns of both the workbooks are fixed every time the sheets ar
generated , For example. I will always be comparing Column C o
workbook1 with Column T of workbook2 , and so on... Can I record
macro which will help me... The sheets are not sorted by default whe
they are generated....

--
Message posted from http://www.ExcelForum.com