04-09-2020 05:19 PM
04-09-2020 08:43 PM
Are the rows aligned together? I imagine not, due to the random selection. If together, it should be easy to select them and use copy and paste as previously selected.
If you are able to hide the other rows that you are not trying to copy, you could then select the rows and use Go to > Special... Visible Cells only (right side of menu). You can get to this by hitting the CTRL button and G at the same time (CTRL+G).
Once you do that it will not select the hidden rows.
Now you can choose to copy (CTRL+C) these particular rows/cells onto your clipboard.
Then go to the new workbook/worksheet and paste the data.
04-09-2020 08:45 PM