From: sugandheshpal on
Using VB Script:

In the same excel have two worksheets.

Sheet 1 and Sheet 2.

Compare the data in between the sheets i.e. Sheet1 and Sheet2 and if the
data matches will paste in Sheet3.

--
Thanks and Regards
Sugandhesh Pal