| 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 | |||
Linear Mode
