Forum Discussion
Moving Row to anther sheet automatically
Yeallow Dear Humans, I'm looking for some advice on how to move the whole row to a new sheet automatically, I have a worksheet in excel web. and 18 Row A -Q header stays in freeze property (ple...
Hi!
Have you considered adding an extra column for the status of that row, where you can put "Done," "In progress," etc.?
Then you can filter your table using that column. The row won't move to the other sheet, but you can filter and see only the rows you want.
Having the row moving "by itself," no another sheet can be done with VBA, but not in version Excel Online. Maybe there are other ways, but these are the ones I can think of now.
Good luck!