Home

Always add in two columns, remove only in one, then clear insert.

%3CLINGO-SUB%20id%3D%22lingo-sub-433164%22%20slang%3D%22en-US%22%3EAlways%20add%20in%20two%20columns%2C%20remove%20only%20in%20one%2C%20then%20clear%20insert.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433164%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%C2%B4m%20totally%20new%20to%20VBA%20and%20the%20more%20advanced%20functions%20of%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20after%20browsing%20around%20on%20Communitys%20and%20Youtube%20for%20a%20week%2C%26nbsp%3B%20I%20would%20be%20very%20greatful%20if%20somebody%20had%20the%20time%20to%20help%20me%20out.%26nbsp%3B%3C%2FP%3E%3CP%3EI%C2%B4m%20trying%20to%20set%20up%20a%20simple%20inventory%20list%20to%20keep%20track%20of%20my%20stock%20of%20hockeyequipment%2C%20but%20I%20can%C2%B4t%20get%20a%20few%20functions%20in%20order.%3C%2FP%3E%3CP%3EWhat%20I%20want%20to%20do%3A%3C%2FP%3E%3CP%3EI%20want%20to%20enter%20the%20change%20of%20the%20stock%20in%20one%20column%2C%20A%2C%3C%2FP%3E%3CP%3EIF%20the%20number%20is%201%20or%20higher%20I%20would%20like%20Excel%20to%20add%20in%20columns%20B%20and%20C%2C%3C%2FP%3E%3CP%3EIF%20the%20number%20I%20enter%20is%20-1%20or%20lower%20I%20want%20Excel%20only%20to%20retract%20from%20column%20B.%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20confirming%20the%20entry%20I%20want%20to%20clear%20column%20A%20without%20removing%20the%20values%20added%20or%20removed%20in%20Columns%20B%20and%20C.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20columns%20I%C2%B4m%20refering%20to%20as%20A%2CB%20and%20C%20is%20actually%20P%2CQ%20an%20T%20in%20the%20worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20do%20this%3F%20And%20how%20do%20I%20do%20it%3F%20%3CSPAN%3EDo%20I%20need%20to%3C%2FSPAN%3E%20repeat%20the%20process%20on%20each%20line%20in%20this%203500%2B%20inventory%20list%3F%20Remember%2C%20I%C2%B4m%20totally%20new%20to%20macros%20and%20VBA.%26nbsp%3B%3C%2FP%3E%3CP%3EGreatful%20for%20any%20help!%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2F%20Terry%20from%20Sweden%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-433164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Terry_H1948
Occasional Visitor

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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies