View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.