i have 2 spreadsheets with 5 column of data on each, on one workbook, w
will call booka,in column c there are part numbers and column f i
quantity. what im trying to do is take the parts numbers and match the
to another set of part numbers on the second book(bookb), and paste th
quantity of that part number next to the qauntity on bookb which i
column as well. i dont need the part numbers to show, im just trying o
match the quantities next to each other and the part numbers arent i
order. so if the way i described is easy or another way is easier.
tried multiple things but just can seem to get it to work. also some o
the part numbers arent even there so those will be skipped. also,. som
of the part numbers dont match, which it would be nice if those can b
highlighted or something, or anything that makes them stand out. bu
basically i just want the first function, mathcing the part numbers t
compare quantities. thanks for any help

--
Message posted from http://www.ExcelForum.com