+ Reply to Thread
Results 1 to 5 of 5

Production and Inventory adjustment??

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2011
    Posts
    14

    Production and Inventory adjustment??

    hello, I'm new to the site, and a fledgeling excel user. I can do basic stuff like simple formulas in cells, but I'm having a bit of trouble figuring out how to make formulas for what I want excel to do now. In a nutshell, I make ammunition for weapons of different calibers. On my first excel sheet, I have balances on hand for each type of bullet that I make, plus another column for the various raw materials that I also have on hand. On my second workbook sheet, I have "recipes" for each bullet. EX: one .45 cal bullet takes one .45 cal case, one .45 cal bullet, one large primer, and 6 grains of powder.

    What I want excel to do is make a reusable form where I can just type in how many bullets I made. lets say I made 10 .45 cal bullets today. I want excel to subtract the components used to make the bullet from my materials balance while also adding the newly made bullets to my bullets on hand balance. And then tomorrow I can just type in that I made 25 more bullets, and it will automatically complete the rest of my workbook.

    I'm willing to learn how to do this work on my own, as I love to learn new things. If someone could give me the basic idea and formulas and point me in the right direction I'd really appreciate it! I can also upload my file if anyone wants to look at it.

    Thanks!
    Attached Files Attached Files
    Last edited by zx7r; 01-12-2012 at 02:45 PM. Reason: upload file

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Production and Inventory adjustment??

    To receive the best help, you should post a sample of your workbook so that users don't have to guess and recreate a workbook.

  3. #3
    Registered User
    Join Date
    01-12-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2011
    Posts
    14

    Re: Production and Inventory adjustment??

    ok, i wasnt sure if file uploading was encouraged or not. uploading now.

  4. #4
    Registered User
    Join Date
    01-12-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2011
    Posts
    14
    Bump. I hope this isnt a huge labor intensive task, if it is even possible. But ive seen excel do many awesome things

  5. #5
    Registered User
    Join Date
    01-12-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2011
    Posts
    14

    Re: Production and Inventory adjustment??

    Still no ideas of tips? what book should I get if I want to learn this kind of work?

+ 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