+ Reply to Thread
Results 1 to 2 of 2

inventory +/-

Hybrid View

lang inventory +/- 03-12-2011, 01:21 PM
nimrod Re: inventory +/- 03-12-2011, 03:39 PM
  1. #1
    Registered User
    Join Date
    03-12-2011
    Location
    MN, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    inventory +/-

    sheet1 has a cell with list validation, a cell for user input, and a button.
    sheet2 is hidden and has 2 columns of reference data. Example below:
    item inv
    nuts 100
    bolts 20
    washers 55
    etc...
    how should I code the button on sheet1 to update inv on sheet2?
    ex: from sheet1 select bolts, enter 4, then click button to adjust bolts inv
    on sheet2 from bolts 20 to bolts 16.
    Last edited by lang; 03-12-2011 at 05:59 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2003
    Location
    British Columbia , Canada
    MS-Off Ver
    03,07,10,13
    Posts
    727

    Re: inventory +/-

    Better description of problem and a downloaded example would really help 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