How to use VBA Code to auto populate with condition in specific sheet

If you don't know the reason you are doing it, then we wouldn't.

Guessing that you might want to change the 2nd line to?

Please Login or Register  to view this content.

You did not set a value for bIsRun so an IF for it won't be of much use.

Thanks Kenneth!

I tried but gave me an error.

Please find attached files.
"WorkBook_A" contains VB codes for few different functions.
Code pasted in Thisworkbook auto increment project number and clear the scoring once submitted;
Code pasted in Module 1 save file in excel & PDF formats at desktop and delete the code pasted in Thisworbook once submitted;
Code pasted in Sheet named "Decision Point" is for populating Sheets in WorkBook_B based on selection (Yes, No, On-hold)

Code pasted in Sheet named "Decision Point" is giving me an error.

I need help to fix it because my knowledge of VB code is very week.

Thanks in advance to all

WorkBook_A.xlsm
WorkBook_B.xlsx