Results 1 to 4 of 4

Help Comparing cost on two work sheets to update cost

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2009
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Help Comparing cost on two work sheets to update cost

    I am trying to figure out how to update cost from a vendors .xls file I want to compare my price list to the vendor price list by OEM number and Highlight any cost that have changed and show the amount of change. I have really tried and tried but I cannot figure out how to do the formula correctly. Any help would be greatly appreciated as I have to do this manually now and we have 4000 parts from this particular vendor.
    Thank You
    Matthew
    Attached Files Attached Files
    Last edited by mbechtel; 06-02-2009 at 09:03 AM. Reason: changing file to xls

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1