Need macro coding for find, copy, and paste

Closed
redspura Posts 1 Registration date Monday July 3, 2017 Status Member Last seen July 3, 2017 - Updated on Jul 3, 2017 at 02:11 PM
Hi Friends,

I need a macro coding for the below example.

In sheet 1 I have extracted webpage results like profile page it includes (Quality see 8,Team handling see 0,Communication see 4)
in sheet 2 I have some skills in column order like
Quality
Team handling
Communication

In sheet 3 same heading I have Quality(A1),Team handling(B1),Communication(C1)

the code will search the data in sheet 1 and find the numbers(8,0,4) like Quality see 8 and copy paste the number in sheet 3 column A2,B2,C2 respectively.

Please help on this thanks in advance.