Hi,
I have two seperate excel files (file1: inventory.xls, file2:order.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
--
merritt
-----------------------------------------------------------------------
merritts's Profile:
http://www.excelforum.com/member.php...fo&userid=3580
View this thread:
http://www.excelforum.com/showthread.php?threadid=55616