How to choose every nth row & paste it as a new table

[satya430]

Hi ,
The problem here is of excessive data. I need to choose every 10th Row data out of around 100,000 rows, it is impossible to choose them manually.

Is there any shortcuts or some MACROS which will enable me to do it ?

[:) Sixthsense :)]

Use a helper column to put a formula

I used this formula in Second Row

=IF(MOD(ROWS($A$2:A2),10),"De-Select","Select")

Drag it down...

Use filter to select the formula result SELECT from the filter list.