B
Bill
For Excel 2007
I would like to a repetitive pattern of rows delete rows from a very large
worksheet with 2000 rows. As example, I would like to delete rows 1, 2, 4, 5,
7, 8, and so on. I would like to keep rows 3, 6, 9, and so on. In this
example, I am deleting two consecutive rows, keeping the next row, deleting
the next two rows, keeping the next row, and so on. There is a pattern of
deleting rows.
I would like to delete these rows in the easiest manner possible, without
deleting each row individually. Also, I would not want to write a macro if
possible.
Any suggestions are appreciated.
Thank you
I would like to a repetitive pattern of rows delete rows from a very large
worksheet with 2000 rows. As example, I would like to delete rows 1, 2, 4, 5,
7, 8, and so on. I would like to keep rows 3, 6, 9, and so on. In this
example, I am deleting two consecutive rows, keeping the next row, deleting
the next two rows, keeping the next row, and so on. There is a pattern of
deleting rows.
I would like to delete these rows in the easiest manner possible, without
deleting each row individually. Also, I would not want to write a macro if
possible.
Any suggestions are appreciated.
Thank you