Previous Topic Next Topic

Need macro coding for find, copy, and paste

Closed
Posts
1
Registration date
Monday July 3, 2017
Status
Member
Last seen
July 3, 2017
 -
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.