Hi guys
I need a codes that does the following:
if i can find HAMMER in column H then add 3 to the corresponding value , so 2 will become 5
if i cannot find HAMMER in column H then find hammer in column A and then add 1 to corresponding value , so 7 will become 8 if column H do not has Hammer.
regards
|It sounds like you are trying to inventory or stock control. You don't need VBA for such projects. I have posted Inventory examples using formulas
i am afraid i need a vba approach for this
Why? Formulas are more efficient than VBA and if it is inventory then it's necessary to keep a track of all incoming and outgoing items. VBA won't provide that.
I've posted them here. I'll attach it for you, This is an example that I made for another question,
1. Opening stock should be entered into the master stock list before starting to use this workbook
2. Enter items received and sold into the register.
3. The formulas in the master stock list will update to show current value
I must put it on my site with an explanation
thank you, it would greatly help me, btw mine is not stock control, its data from simulation( stresses etc at nodes), i uploaded a makeup excel file so that its easier to understand