Macro to v look up and compare reports

Hi,

Need help to automate the manual activity that i do.

My excel file has 2 reports in sheet 1 and sheet 2. In both the reports “ID” is common. With a v lookup i will check if all the Ids in sheet 1 are available in sheet 2.
If there are any Ids that are not available in sheet 2, i copy those Ids alone and will paste in sheet 3. Then i will bring the rest of the details against those Ids by v lookup.

I am trying to create a macro that will automatically look up and bring the Ids and other details to sheet 3.

Attached is the sample data.. In the sample i have already pasted the required results in sheet 3.. Please help me with codes to bring the same results..

Hi arun.sj,
try so

Please Login or Register  to view this content.

Originally Posted by nilem

Hi arun.sj,
try so

Please Login or Register  to view this content.

Thanks a lot for replying.. the code is working as expected..

i need one more help.. It would be good if there is border across the results in sheet 3.. border in all the cells with black or blue color..

Requesting for your help to update the above code..

Hi Team,

Please help...

You can use conditional formatting (see the attached file)

Originally Posted by nilem

You can use conditional formatting (see the attached file)

Thank you so much..