I need help in writing Macro to compare data in two different excel workbook

Hi,

I need a help in writing macro for the below logic,

a.)I have to choose first excel file from the directory and selected file should be displayed.
b.)After Selecting I have to copy the data from selected excel sheet to a new excel sheet let say into sheet1 of a new workbook.
c.)Choose the second file and copy the data to sheet2 of a new workbook.
d.)Then I have to compare the data of sheet1 and sheet2.

I am attaching the macro sheet which i have used for your refernce

where in the attached macro ....if there in an empty cell macro is not copying the complete data...Please advise

I just Want to know how many rows and columns that we can compare using macro?

Is it possible to compare a 7 lakh record in a macro?


The macro is used to compare is below

Please Login or Register  to view this content.

Please advise