Gather similar data in two tables

Hello everyone

In Sheet1 I have two tables and I need to compare these two tables in another sheet
The logic will be as following:
=====================
Look at the value in column A and if found in Column F then grab the same value in both columns to the same row and so on
As for these similar rows in both tables would be highlighted ...

After all there will be different values in both tables (these will be put beneath each table and sorted in ascending way)

I have put the expected output in Sheets("Output") to give you the final desired result)

Hope it is clear
Thanks advanced for help

Try this. I'm assuming there is only one match for each in column A and F

Please Login or Register  to view this content.

Thanks a lot for reply and for working solution.. But I need to keep original data as it is (original data cleared)

Is it possible to do this task using VBA arrays or dictionary?

If it is possible to do with arrays or dictionaries I'm not aware how.

Maybe :

Please Login or Register  to view this content.

Thanks a lot Mr. Omar
Mr. Karedog thank you very much for this awesome solution. You know I am admired of VBA arrays

Just a little point : I don't need to sort similar data .. The sort process will be executed just for the different in the two tables
But as for the similar I need the same order as they were in Sheet1 Column A
Best Regards

Maybe like this ?

Please Login or Register  to view this content.

That's really awesome my dear friend.. Thanks a lot for great and wonderful help
Kind regards

You are welcome, thanks for marking the thread as solved and for the rep.points.


Regards