+ Reply to Thread
Results 1 to 9 of 9

buttons to add/subract from inventory.

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    buttons to add/subract from inventory.

    I am trying to create an inventory for tires.

    Id like to add functionality to the 2 buttons created which should add & subtract from the inventory list. If the tire size entered is not available, I'd like to use the same add button to add the specified size into the inventory list.

    Im hopeful i can get some help here!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: buttons to add/subract from inventory.

    Last edited by Samantha1123; 11-12-2012 at 09:08 AM.

  3. #3
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: buttons to add/subract from inventory.

    I've attempted to manipulate the vb script from the response received from the below thread with no success. Im new to this, and any assistance would be much appreciated!

    http://www.excelforum.com/showthread...t=#post3003838

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: buttons to add/subract from inventory.

    Please think about this first.

    If the tire size entered is not available, I'd like to use the same add button to add the specified size into the inventory list.
    What if a typo is made? It could mess up your inventory list, beyond comprehension.

    There is a lot more involved in managing Inventory, than many would realise. That is why there are from "simple", to very sophisticated Stock Programs available outside of Excel.

    A very simple basic Inventory Program in Excel, can turn into a massive amount of Coding and requires very careful planning, structure and definition. "Don't just fire from the hips."

    Personally, I try not to get involved in "Developing" any such Inventory programs, as they always turn into a very time consuming process, just to be totally discarded or having to be written over because a very simple point was overlooked right from the outset, which causes a major upset further down the process.

    Hope you come right.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  5. #5
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: buttons to add/subract from inventory.

    Thank you, Winon for that point. I would certainly consider this once our inventory increases.

    At this time, I will be the only one managing this list and we have a stock of what i beleive to be less than 200 used tires. Maybe, before entering the tire size into the list it can check against the database to ensure its a valid combination of size....I just want to be able to have a personal reference should someone call in to inquire whether or not we have a size and not have to send a mechanic to check each one individually.

    Regards, Samantha

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: buttons to add/subract from inventory.

    As it is at the moment, the Database does not show a tire size of 135-20-14 as shown on the User Sheet.
    Also why would you have a seperate WorkBook for "Used Tire Inventory"? Could you not just include it in this one WorkBook on a seperate Sheet?

  7. #7
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: buttons to add/subract from inventory.

    I realize that a cross-check to the tire sizes listed has not been established...Its something that i would like to add to prevent errors as you mentioned earlier. At this time however, I'd just like to get those buttons to work by adding and subtracting from the inventory.

    I suppose that both database and inventory sheets can be combined.
    Last edited by Samantha1123; 11-12-2012 at 11:05 AM.

  8. #8
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: buttons to add/subract from inventory.

    hi, Samantha1123, option, please check attachment, I hope I understood the whole idea correctly. The sheet "User" has been protected with no password to protect formula cell - A5. Ranges A3, A8, A10 are available for input. Ranges A8 and A10 use data validation to ensure only integer numbers are allowed. If something was intepreted wrongly feel free to amend the codes or whatever
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    11-09-2012
    Location
    Pennsylvania,USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: buttons to add/subract from inventory.

    Watersev, this is exactly what I needed. Thank you very much. I'll play with it from here!

+ 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