Copy, find, paste from one work sheet to another

[dushpatel]

Hi I am a noob and looked everywhere to find a way to do the follwoing:
I want to create a macros or VB to start a search from sheet1 C2 then do a "find" in sheet2, if result is found to copy the row into sheet1 P2, then to loop this for C, C4, C5... and so on..
I have attached the file to this thread...
Please can someone help.

merge.xlsb

[AB33]

Your request is not clear.
I am assumed you want to search for an exact match in column C of sheet 2 and if a match is found, return the entire row of sheet2 in to sheet1,column P.
As your file is too large for the limit size of this forum, I have to delete half of the data of sheet1.You need to run it from the original sheet1.