Hoping some kind person can help me with some VBA code
I have a worksheet named "caseload" columns A-T
I'd like to use a VBA code to move complete rows to a new worksheet named "finished episodes" when Column A has the word either "Discharged" or "died" (which is the result of a formula in this cell)
I have one Title Row so from row 2. I'd also like to keep the destination data, so preferably not to overwrite data in the destination worksheet but add it to the end.
Please can someone help with this?
Thanks
I have a worksheet named "caseload" columns A-T
I'd like to use a VBA code to move complete rows to a new worksheet named "finished episodes" when Column A has the word either "Discharged" or "died" (which is the result of a formula in this cell)
I have one Title Row so from row 2. I'd also like to keep the destination data, so preferably not to overwrite data in the destination worksheet but add it to the end.
Please can someone help with this?
Thanks