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 (please see the attachment)
What I would like for example if something is done or I change something that row moves to sheet 2
Any suggestion will be very helpfull
Thank you
1 Reply
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!
