Comparing Excel Workbooks

  • Thread starter Thread starter IndianTechie
  • Start date Start date
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....
 
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
Comparing two workbooks - Excel 2010 - not using Add-ins 2
Return Rows from another workbook 7
STOP close button on another workbook 6
Vlookup or Match VBA 6
Comparing Wookbooks 6
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copy cell value from one worksheet to matching worksheet in another workbook 4

Back
Top