Hi Experts,

I am working on a SharePoint client, used by many users with locked excel.
I have the excel password and I have a request from users
1. Based on certain cell values, they want to move the rows to another tab and delete the contents.

I could not use VBA as the users need .xlsx to open. Any ideas to make this happen,
The last alternative is to replace cells with empty cells, based on excel formula, then I would go ahead each day, filter out blanks or keywords "Delete" and delete those rows.
If I have to go for the last alternative is this way to go?
If (Conditions) SUBSTITUTE CELL with Delete or Blank? Is there a way I can do it for the entire row?

Example

If cells A5 = " Delete Rows"

Rows 15 to 19, copy contents to tab and delete the rows, row 15 to row 19.

Thanks a lot