Comparing Excel Workbooks

I

IndianTechie

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

Ed

What kinds of comparisons do you want to do? Number of entries?
Duplicate entries? Cell-for-cell matching?
What types of data are you working with? Dates? Currencies? Numbers?
Phrases of text?
Give us a bit more, please, and we'll be glad to help.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two workbooks and hi-light matches 0
Return Rows from another workbook 7
Comparing cells in workbooks 2
Comparing Wookbooks 6
Compare and Copy/Paste b/w Two Workbooks 17
User Provided Path - Compare 2 Books 1
Update Excel file 4
Comparing values or text in 2 different workbooks 2

Top