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!

Find selection
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


C3 wrote:
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!