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

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

Hi,

It looks like the vlookup can only work within the active excel sheet. But
again, I'm not the Excel expert...

Best regards
M

"Tom Ogilvy" skrev i en meddelelse
...
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

Nope. =Vlookup() will work between sheets of the same workbook or between
different sheets of different workbooks.

Debra Dalgleish has some very nice notes for =vlookup():
http://www.contextures.com/xlFunctions02.html

Mads Westen wrote:

Hi,

It looks like the vlookup can only work within the active excel sheet. But
again, I'm not the Excel expert...

Best regards
M

"Tom Ogilvy" skrev i en meddelelse
...
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




--

Dave Peterson