From a single sheet, I am trying to delete a certain block of rows, which is dependent on the total number of rows and leave a sample of ~ 100 rows of data. For example, if I have a sheet with 1000 rows of data, I want delete every row except rows 10, 20, 30, 40, 50, 60, 70, 80...etc (leaves ~100 rows). If I have a sheet with 300 rows of data, I want to delete every row except rows 3, 6, 9, 12, 15...etc.

I've been searching various forums but I can't find anything similar that would accomplish this task. Any comments appreciated. Thanks.