Find selection

[C3]

Help!

How to make a macro who will find a cell in another worksheet which contains
a number (column A), select cell in a row (not entire row, cell in column B)
then copy it to a first worksheet in column F in a blank cell.

Example:
First worksheet:
A B C
D E F

42444 8002455024008 2400 DISNEY ASSORTMENT /72 kom 11,77
499 8002455041005 4100 BURAGO MALI 1/43 24/72 kom
7,99
497 8002455042002 4200 METAL MODELS 2 KOM /24 kom
15,98


Example:
Second worksheet:
A B

42444 100
499 200
497 150

Thanks!

 

[Frank Kabel]

Hi
not quite sure how column B on your second sheet was filled but why not
use something like VLOOKUP? Or hast it to be a VBA solutio b