Searching Database

[merritts]

Hi,

I have two seperate excel files (file1: inventory.xls, file2rder.xls
each with two columns (col a: part #, col b: quantity). Using the par
# from order.xls i would like to search inventory.xls for the same par
# and add/subtract the respective numeric quantities.

*the part# is a combination of letters and numbers, roughly AAAA####

Thank

 

[Mark Driscol]

You could put something like this formula in Cell C1 or order.xls.

=SUMIF('[Inventory.xls]Sheet1'!$A:$A,A1,'[Inventory.xls]Sheet1'!$B:$B)

Mark

 

[merritts]

mark,

I was hoping to add other functions later and would like to implemen
it through macros. Is this possible?

Thanks,
Andre