Rows moved, where did they go?

Alta

I highlighter a number of rows on a sheet that I intended to move to another sheet. While trying to locate the correct sheet to move them to, they disappeared. The activity log shows that the rows were moved but I cannot figure out which sheet they moved too. How to find that information?

Paul Newcome

Go through the process as if you are going to move more rows. In my experience, the sheet that it is defaulted to when the window opens to allow you to select is the last sheet that rows were moved to.

Alta

Thanks. Thats a good point. In the end I did a search for something I knew was on the one of the moved rows and I found it but your method should work well too.