Hello all, first off let me start by saying I am a rookie at excel. I am comfortable formating cells, running formulas but thats about it.
I have a spread sheet that is an inventory for approx. 50 items or more. what i would like to do is create a sheet that has the following colums; total, assigned, available. for each item
i need it to do a couple of things,
1st. have a button w/ a macro assigned that I can select a cell and then click either ADD or Subtract button and have it do so by the value of 1
2nd. I want the total to remain the same and the assigned/ available adjust accordingly.
Example;
I have 400 Long Sleeve T-Shirts size XL, 225 are assigned and 175 are available.
I now have to assign 5 of the 175 available, so I want the assigned to go up to 230 and the available to go down to 170. All by just clicking the assigned column then clicking the add button 5 times.....
Confused? So am I.... lol.
Once I get this done, how will I be able to increse the total if more are purchased? BTW all newly purchased items will go in the available column
Is this way outta my league?
Thanks for your help