File comparing, fill file2 with value from file1
 

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

File comparing, fill file2 with value from file1
 

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

File comparing, fill file2 with value from file1
 

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

File comparing, fill file2 with value from file1
 

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