+ Reply to Thread
Results 1 to 1 of 1

Trying to compare inevntory sheets and carry differences to another worksheet.

  1. #1
    Registered User
    Join Date
    07-23-2012
    Location
    USA
    MS-Off Ver
    Excell 2010
    Posts
    3

    Trying to compare inevntory sheets and carry differences to another worksheet.

    I am trying to compare two inventory sheets. For instance I have the last months inventory sheet (inventory test) and I want to compare it to the inventory sheet (the exact same sheet just with an updated inventory; Inventory test 2) that is turned in for this month. I would like for the differences to be added to another workbook (sales test). When the item is carried over, I would like for it to carry over the part number (Colum A on Inventory test), Part name (Colum B on Inventory Test) and the difference of the on hand quantity onto the "Sales Test" workbook in the corresponding cells.

    If the above is to difficult or cannot be done. Can I get excel to at least compare the numbers in Colum E on "Inventory Test" to the numbers in colum E on "Inventory test 2" and and show the discrepancies with at least the number difference and part name in another worksheet?

    Any help would be GREATLY appreciated.

    I have also attached the above mentioned workbooks
    Attached Files Attached Files

+ Reply to Thread

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