Comparing two large excel speadsheets.

[UEHOOSIER]

I have a large original report of 200 rows and 60 columns. I need to compare it to be exactly the same as the test report. It contains numbers and words. I am currently using the cell speak to compare. Is there is a quicker way?
Thank you.

 

[GlennUK]

Have a third workbook, linking to cells in those to compare, like:

='[Original rep.xlsx]Data'!A1='[Test rep.xlsx]Data'!A1

in cell A1, copied to cover the range of the reports.

The cells that are the same will be TRUE, and those that don't will be FALSE.

If you have access to Excel 2013 (Microsoft Office Professional Plus 2013) or through Office 365, you have access to a new feature in Excel that allows you to electronically compare two workbooks and identify any differences in those workbooks. This new feature – Compare Files – will also do what you want:

Comparing Two Workbooks with Excel 2013's Compare Files Feature

 

[UEHOOSIER]

Thank you! I will give it a try!

 

[bountiful]

Hey thanks guys for all the participation, this really is a great board!
I did'nt quite understand what you were saying before when you were trying to help me, sorry!

here's my function as it is now. Have I fxed what you were talking about?

Public Function InColumnn(strSearch As String, r As Range) As Boolean
Dim c As Range
Dim result As Boolean
Set c = r.Find(strSearch, , xlValues, xlWhole)
If c Is Nothing Then
    result = False
    'InColumn = False    ' this makes Excel unhappy
Else
    result = True
    InCoulumn = True     ' whereas this does not...
End If
End Function

 

[GlennUK]

Hey thanks guys for all the participation, this really is a great board!
I did'nt quite understand what you were saying before when you were trying to help me, sorry!

here's my function as it is now. Have I fxed what you were talking about?

Public Function InColumnn(strSearch As String, r As Range) As Boolean
Dim c As Range
Dim result As Boolean
Set c = r.Find(strSearch, , xlValues, xlWhole)
If c Is Nothing Then
    result = False
    'InColumn = False    ' this makes Excel unhappy
Else
    result = True
    InCoulumn = True     ' whereas this does not...
End If
End Function

Are you sure you've posted to the right thread?