Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 30th 08, 04:48 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 162
Default 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.

  #2   Report Post  
Old September 30th 08, 06:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
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.

  #3   Report Post  
Old September 30th 08, 06:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 162
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help Needed: Comparing cell values and deleting rows [email protected] Excel Discussion (Misc queries) 1 September 19th 06 02:39 AM
Adding and Deleting rows - update formulas help needed. bperks Excel Worksheet Functions 1 May 31st 06 08:30 PM
Help summarizing data needed Jon Excel Worksheet Functions 4 November 27th 05 05:44 AM
help needed converting data MarkP Excel Discussion (Misc queries) 7 August 25th 05 11:03 PM
Help in getting external data needed please Alex H Excel Worksheet Functions 1 June 17th 05 01:38 PM


All times are GMT +1. The time now is 01:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017