View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AndreaW
 
Posts: n/a
Default Update rows with new pricing

I receive daily updates from various suppliers. Instead of dragging and
dropping their new data into my one master price list, I would like to have
Excel look up and replace the old prices with the new prices into my list for
each supplier. Is there an easier way of doing this instead of doing so
manually (drag and drop)? The daily updates can be anywhere from 5 entries
to over 3,000. 5 is ok to do manually, but 3,000...yikes! I have 2 columns
within my lists which are identical to 2 columns from each of my suppliers.
Each supplier's price list contains approximately 8 columns. I need to
ensure I replace the data into the proper row and thought Excel could perform
this tedious task in short order.