ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Deleting Rows With Non-Needed Data between Needed Data (https://www.excelbanter.com/excel-worksheet-functions/204531-deleting-rows-non-needed-data-between-needed-data.html)

Daren

Deleting Rows With Non-Needed Data between Needed Data
 
I have a very large data set that has 10 rows of non-needed data, then 20
rows of needed data, then 10 rows of non-needed data, then 20 rows of needed
data, etc for many lines. Is there a macro or commands for deleting the
non-needed data?

Thanks.

Sheeloo[_2_]

Deleting Rows With Non-Needed Data between Needed Data
 
How will you identify the row contaning 'non-needed' data?

"Daren" wrote:

I have a very large data set that has 10 rows of non-needed data, then 20
rows of needed data, then 10 rows of non-needed data, then 20 rows of needed
data, etc for many lines. Is there a macro or commands for deleting the
non-needed data?

Thanks.


Daren

Deleting Rows With Non-Needed Data between Needed Data
 
It is with a lot of text that doesn't need to be there. I've actually
figured this out...it was just a simple sort, so the issue is closed. Thanks
for your assistance.

"Sheeloo" wrote:

How will you identify the row contaning 'non-needed' data?

"Daren" wrote:

I have a very large data set that has 10 rows of non-needed data, then 20
rows of needed data, then 10 rows of non-needed data, then 20 rows of needed
data, etc for many lines. Is there a macro or commands for deleting the
non-needed data?

Thanks.



All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com