Okay, let’s see if I can explain this clearly enough. I have 2 excel files, one is just a master listing of some product codes (master listing). The other file is a listing of some of the product codes, along with quantities next to them (inventory listing). Now, what I’m trying to accomplish is to filter these two files together and still have my master listing, but with the product codes next to them. Something like this:
Master Listing file:
500251
500313
500452
500556
500617
500721
Inventory Listing file (42,214, and 7 are quantities):
500313 – 42
500556 – 214
500617 – 7
What I’m trying to accomplish is a spreadsheet that filters the data into the master listing, something like this:
500251
500313 – 42
500452
500556 – 214
500617 – 7
500721
BTW, The quantities are in a different cell than the product codes. I use excel a lot, but this is a little over my head. I’ve also attempted at MS Access, but I’m a serious noob for that program. Any advice? Thanks!
2007-12-31
06:54:33
·
1 answers
·
asked by
Adam
1