Find selection
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!
|