Update Values based on status update

Hi,

Hope somebody can help, I have the below code but I need help making a few changes. At the moment it -1 if the status is set to "used" and +1 if changed to "returned". However, I would now like it to also look at column 12 (L) for a second status. If column 12 is set to "damaged" or "faulty" I would like it to -1. The other problem is that if I select "used" or "returned" and then select the same status again it changes the value again. So, if i select "used" it will deduct one and then if I select it again my mistake it will deduct another one.

Please Login or Register  to view this content.

Hope this makes sense.

Cheers

Maybe:

Please Login or Register  to view this content.

Hi,

Thank you for your help, Not sure if i have done something wrong but i have put the above code in but it doesn't seem to make any changes to the QTY's when changing the statuses.

The statuses / columns are on a sheet called Parts Usage

• Used = Colum K
• Returned = Column K

• Damaged = Colum L
• Faulty = Column L

The number that needs to be updated is on a different tab called Parts Master in column G

I would like the following to be deducted or added based on the Status entry

• Used = -1
• Returned = +1
• Damaged = -1
• Faulty = -1

Can you help update this please?
I have attached an example sheet.

Regards,
Jamie

Try it now:

Please Login or Register  to view this content.

Hi JDobbsy,

Where you put the code is important. If you put the code behind something called a "Module" it won't work. You need to put it behind the Sheet module. Read:

http://www.cpearson.com/excel/Scope.aspx

I found a glitch and fixed it - try it again!

Hi JDobbsy,

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.