Forum Discussion
Excel VBA help
I have a document containing data that I would like to have moved to another sheet when it is marked "Y" for completed. The completed column is J, the original sheet is called 2020 Projects and ...
ISubodh_Tiwari_sktneer is the
Private Sub Worksheet_Change(ByVal Target As Range)
required to be the in the header? I cannot figure out how to save this macro with that header.
When running the macro without that header I get a Run time error '424'; Object required error.
Please find attached a dummy file with the code on 2020 Projects Sheet Module for your reference.
Also, refer to the below images to know how you should proceed in order to implement this code to your workbook.
Step1:
Step2:
After the above step, a code window will be popped up as shown below.