Unanswered: VBA to move rows in worksheet with certain cell criteria to a new worksheet
Background: I was recently given a tracking spreadsheet that I need to edit using some VBA functionality. Unfortunately, I have limited experience with VBA and your help would be GREATLY appreciated.
Question: How do I create functionality so that when I mark Column "Z" in my Working File spreadsheet as "Closed", it will automatically be moved to a new spreadsheet entitled "Closed" in the workbook?
Attachment: I have attached an example file of the various columns that I have within this workbook.
I tried to use the following code but it keeps giving me an error:
Dim SourceSheet As Worksheet
Dim TargetSheet As Worksheet
Dim SheetNames As Variant
Dim i As Long
Dim LR As Long