I would like to copy every 10th cell from a column of several thousand. Is this possible?
I found a question on stack-overflow, that addresses a similar problem. I believe that one or more of the answers might have the solution that you're looking for. The top 2 answers I think might do it for you. The first answer involves a formula, and the second one involves data sorting in a certain way.
Click here to see the question on Stack-Overflow.