Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
Adding and Deleting rows - update formulas help needed. | Excel Worksheet Functions | |||
Help summarizing data needed | Excel Worksheet Functions | |||
help needed converting data | Excel Discussion (Misc queries) | |||
Help in getting external data needed please | Excel Worksheet Functions |