PPE control Form

Copper Contributor

Hi all,

 

I am trying to set up a Sign out sheet for the PPE that some of our engineers use and to remove it from the stock value.

 

Essentially in Cell B3 in the sign-out sheet page, there is a drop-down with a choice of a few PPE items.

 

Depending on what is selected there for sign-out i want to subtract 1 from the correlating item in the stock sheet page.

 

an example would be if sign-out sheet B3 = Safety glasses then stock sheet B3 would reduce by 1 form 15 down to 14.

Benfoubister96_1-1702460663941.pngBenfoubister96_2-1702460681582.png

 

I hope this makes sense, 

thank you so much for any help!!!

2 Replies

@Benfoubister96 

You can check if the worksheet change event in the attached file returns the intended result if you change cell B3 with the drop-down in the sign-out sheet.

Hi,

Yeah that's seems to do what I was looking for exactly.
Thank you, I am still quite new to the more technical aspects of Excel.