Apr 10 2019 04:16 PM
Hi!
I´m totally new to VBA and the more advanced functions of Excel.
So after browsing around on Communitys and Youtube for a week, I would be very greatful if somebody had the time to help me out.
I´m trying to set up a simple inventory list to keep track of my stock of hockeyequipment, but I can´t get a few functions in order.
What I want to do:
I want to enter the change of the stock in one column, A,
IF the number is 1 or higher I would like Excel to add in columns B and C,
IF the number I enter is -1 or lower I want Excel only to retract from column B.
After confirming the entry I want to clear column A without removing the values added or removed in Columns B and C.
The columns I´m refering to as A,B and C is actually P,Q an T in the worksheet.
Is it possible to do this? And how do I do it? Do I need to repeat the process on each line in this 3500+ inventory list? Remember, I´m totally new to macros and VBA.
Greatful for any help!
// Terry from Sweden