Hello,
I have a sheet (many sheets!) with 2 columns, 50001+ rows.
Row 1 is column headers.
Column 1 values are numbers in increments of 1 starting at 200.
I need to remove groups of rows, in various increments, based on the value in column 1.
For example,
If the value in column 1 is between 500 and 600, leave rows with column 1 values in increments of 5.
So, remove all rows except 500, 505, 510, 515, 520, etc.
If the value in column 1 is between 600 and 1200, leave rows with values in increments of 100.
So, remove all rows except 600, 700, 800, etc.
And so on - more of the same with different ranges and increments.
In the end, I need to leave the row with a value of 45559 and delete all remaining rows.
I'll greatly appreciate any help in writing a macro to do this.
Thank you!
T
I have a sheet (many sheets!) with 2 columns, 50001+ rows.
Row 1 is column headers.
Column 1 values are numbers in increments of 1 starting at 200.
I need to remove groups of rows, in various increments, based on the value in column 1.
For example,
If the value in column 1 is between 500 and 600, leave rows with column 1 values in increments of 5.
So, remove all rows except 500, 505, 510, 515, 520, etc.
If the value in column 1 is between 600 and 1200, leave rows with values in increments of 100.
So, remove all rows except 600, 700, 800, etc.
And so on - more of the same with different ranges and increments.
In the end, I need to leave the row with a value of 45559 and delete all remaining rows.
I'll greatly appreciate any help in writing a macro to do this.
Thank you!
T