so here is my situation.
my small business keeps all my products on a database, about 1000-1200 products.
the distributor i order from sends out their excel sheet/product list once a day or more with updated info {prices, descriptions, instock, etc.} but their data sheet has 20,000 + items on it, which is way more then i have.
if i have to buy software or an add-on that is fine, just link or tell the general name of what i am looking for, but here is my problem, i need to update my sheets by product name/UPC, NOT by row or column number.
lets say my upc is 123412341234, how would i have excel look at my sheet, and no matter what cell it is in, update the same row based off that upc. the column layout will never change, its the rows where the product is located that changes. so one day my upc 123412341234 might be row 5005, but next day it might be row 23, but it will always be COLUMN b, so how would i , or is there software that could recognize all of column B and say "match upc in column B with upc in column C of distributor sheet" and update all info in other columns of the same row accordingly"?
if this is confusing, try this.
product AAAA is 29.99, but distributor marked up priced to 39.99, so how do i update the price cell according to the product name?
thanks
my small business keeps all my products on a database, about 1000-1200 products.
the distributor i order from sends out their excel sheet/product list once a day or more with updated info {prices, descriptions, instock, etc.} but their data sheet has 20,000 + items on it, which is way more then i have.
if i have to buy software or an add-on that is fine, just link or tell the general name of what i am looking for, but here is my problem, i need to update my sheets by product name/UPC, NOT by row or column number.
lets say my upc is 123412341234, how would i have excel look at my sheet, and no matter what cell it is in, update the same row based off that upc. the column layout will never change, its the rows where the product is located that changes. so one day my upc 123412341234 might be row 5005, but next day it might be row 23, but it will always be COLUMN b, so how would i , or is there software that could recognize all of column B and say "match upc in column B with upc in column C of distributor sheet" and update all info in other columns of the same row accordingly"?
if this is confusing, try this.
product AAAA is 29.99, but distributor marked up priced to 39.99, so how do i update the price cell according to the product name?
thanks