Reset cell based on other cell contents

[TY2]

Hello and thank you for any help!!

I am working on a PTO spreadsheet. The last piece missing is being able to reset the PTO Used column "C" to "0" if the employees anniversary date "H" is equal to "True". Column "C" cannot contain a formula since PTO taken will be manually entered there.

Background info: Employee's earn a particular amount of PTO to use throughout the year. It does not rollover or accrue, and resets to whatever they are allotted based on years with the company on their anniversary date. All that works in the spreadsheet, but I need to 0 the amount taken on their anniversary date as well.

Thanks again!!!
TY

[Paul]

You can use the following macro in the worksheet module for Sheet1 (right-click on sheet tab and select View Code, then paste this code into the vb editor window). Anytime your sheet calculates it should reset column C to 0 if column H changes to TRUE in that row.

Please Login or Register  to view this content.

I also changed two of your formulas a little.

In cell G2 use this instead of the nested IF's. Fill down col G as far as needed:

Please Login or Register  to view this content.

In H2 you don't need the IF statement. The AND function will either result in TRUE or FALSE automatically. (Plus, your T/F results were strings, not boolean values.) Fill down col H as far as needed.

Please Login or Register  to view this content.

[TY2]

You are AWESOME!! Thank you very much!