Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching Database
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching a linked database | Excel Discussion (Misc queries) | |||
Problems searching a database and reporting all occurrences of a v | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
Searching for variables in excel database | Excel Discussion (Misc queries) | |||
Searching a database in excel | Excel Programming |