Comparing the Data between One Sheet to Another Sheet, and Paste to Different Sheet

Hi,

This work is challenging for me, now am doing Comparing the Data between One Sheet to Another Sheet, and Paste into Different Sheet.

I am Manually Comparing the Data between two different sheet, If the Data is matching, or Not matching, those data i have document in other sheet, So i have lots of records available. so manually doing its very difficult, but macro can compare the data. please help me. I will give the details of my process and example sheet is attached here....

Data 1.xls == This sheet have multiple tab with data and different order no.(Multiple Tab with thousands of records available)
orderNumberModified.xls == Modified data available. (Compare the OrderNumber to Data1.xls)

Now we have to compare the modified.xls and Data1.xls... For modified.xls have ORDERNUMBER available, that Numbers match with all tabs from Data 1.xls sheet.

If ORDERNUMBERS are matching, Need to copy the entire row from modified.xls To AVAILABLE TAB from Comparedata.xls sheet, If ORDERNUMBERS is not matching, copy the entire row from modified.xls To NOTAVAILABLE DATA tab from comparedata.xls sheet.


Thanks

This is urgent. Appreciate any quick response.... Thanks

This is the PERFECT use for MS ACCESS. Do you have it?

No i dont have... i need through macro.....

i am also looking for a similer kind of help.....With the topic "How do i reconcile the data with my data from many work books."

Hi, amiable!
I saw your message only now, sorry.
does the problem still urgent?