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.

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.

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.