Possibly look at the vlookup formula in Excel help.

--
Regards,
Tom Ogilvy


"Mads Westen" wrote:

Hi,

I have a sheet with a lot of stocknumbers and colums for every month where a
amount is typed.
Every month I get a smaller sheet with ex. 15 stocknumbers and some amounts
for each stocknumber.

I want to be able to search the stocknumbers from the monthly sheet and fill
the amounts into a colum of predefined choice in the big sheet.
So like this:
I have a stocknumber with amount 10 in the montly sheet. I activate some
button/code, that searches the stocknumber in my large sheet, and fills
amount 10 into a colum in the row for the right stocknumber.

I'm not the macro/excel genius...

Best regards
M