Hi, I'm creating a sheet for the employees in my retail store. The spreadsheet has a column for the different items that I'm selling, and another column for the number of these items that I have in stock. Next to each of the item, I'd like to create a button.
So here is my question:
How do I assign a macro to the button such that it'll deduct 1 from the 'no. of stock' each time the button is clicked on?
Thank you in advance.
March 20, 2010 6:53 AM
April 24, 2010 6:30 PM