How to copy one in ten row?

**Oleksandr** · 11-28-2009, 03:23 PM

Hello,

I need to mark 1st, 10th, 20th, 30th etc. rows and copy them to another document, how I could do it?

Could you plese help me?
Thank you in advance!

**Richard Buttrey** · 11-28-2009, 04:08 PM

Hi

=MOD(ROW(),10)

copied down against your range of cells, then filter the range on the value 0, (or if you're not starting in row 1, whichever integer marks each 10th row), and copy paste as required.

HTH

**solnajeff** · 11-28-2009, 04:11 PM

Hi

I am not sure if this is exactly what you are looking for but you can probably adapt it to fit your requirements.

There are two macros in the example the first copies every tenth row to sheet 2, the second copies the first row and then every tenth row.

Regards

Jeff