Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Help a total Noob out with macros etc

0

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

excel
posted by: Beyondnovice on Mon Mar 2, 2020 at 11:44 pm
Answer
Discuss

Discussion

This is some sort of stock keeping program. Google for what's available on the Internet and then customized what you find to your particular needs and ideas.
Variatus (rep: 4889) Mar 3, '20 at 4:56 am
Add to Discussion

Answers

0

Hello, Beyondnovice

I send you a possible solution. 

Must select a cell in the "Available" column and cell in same row in "Item" column must be not empty, then Excel asks for new purchased items, you have to enter a number, so Excel adds the number to available items

Must select a cell in the "Assisng" column and cell in same row in "Item" column must be not empty, then Excel asks for new assigned items, you have to enter a number, so Excel adds the number to assigned items and sustract it from available items

I hope this can help you.

Regards
Basilio

posted by: Basilio (rep: 105) on Mon May 18, 2020 at 12:05 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login