+ Reply to Thread
Results 1 to 3 of 3

Copy New Inventory Items To Sales Sheet

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excell 2010

    Copy New Inventory Items To Sales Sheet

    Truck test.xlsxSales Ticket Test.xlsxInventory Test.xlsxI am trying to get excel to compare an inventory sheet to my master inventory sheet and then carry items that have changed over to a sales order. I don't know if this can be done and I am new to running Macros and other advanced tools in excel.

    When an inventory sheet is turned in, I would like to pull the master inventory and have it compare colum E on the inventory sheet to colum K on the master inventory sheet. Then I would like it to carry over the part number, item name, cost and quantity difference to a sales order on another worksheet.

    I have attached the workbooks. What I am looking for is:

    1. Colum E on inventory test(light blue) be subtracted from colum K on truck test (light bue).

    2. Then the difference, part number, cost and item discription brought over to the Sales test spreadsheet in the correct order and cell. In essence for it to generate the sales order reflecting the used items.

    Any help or ideas would be great.
    Last edited by tido208; 07-25-2012 at 04:37 PM.

  2. #2
    Forum Expert
    Join Date
    The Netherlands
    MS-Off Ver
    Excel 2016

    re: Copy New Inventory Items To Sales Sheet

    You get better help if you post an Excel-example of your workbook, without confidential information.
    Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
    Use BEFORE/AFTER sheets if that helps make it clearer.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010

    re: Copy New Inventory Items To Sales Sheet

    Hello tido208 ,

    Welcome to the Forum!

    The quickest way to develop a solution for you would be to have a copy of the workbook. If it contains any sensitive information, please redact it before you post.

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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