Hello everyone,

I have already made Microsoft Access databases but now I need to make one
small VB program in Excel.
I have 2 Sheets.
In Sheet 1 I have 3 columns like this:

Reference number Description Price/Eur

689023 Socket 2,45
23489 Plug 0,98

There is a lot of reference numbers (cca 8 000).

In Sheet 2 I have table just like this but with different Prices and small
number of
referent numbers (cca 200).

How can I make VB code which will find all Referent numbers from Sheet 2 in
Sheet 1 and put new Price from
Sheet 2 to Sheet 1?

thank you in advance,