Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Deleting rows based on values in a a cell in the row
I deal with a number of huge spreadsheets and need to remove all rows with
the values 2 through -4 in col AE; first I sort AE in descending order, then manually find the first occurance of 2 in AE, then manually select rows until the first value occurance after -4. This may involve 100,000s of rows and is very time consuming, even using Page Down... Can anyone suggest a macro to to fully automate this .. I have tried recording a macro but it does not seem to handle handle the fact the first occurance of a 2 changes each time the spreadsheet is generated. Problems of a novice user, and thanks in advance for your help |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Deleting rows based on values in a a cell in the row
Hi Martin,
This can be done with a macro but after sorting try selecting the first row with value 2 (click the row number at left of the screen) and then use the scroll bar to scroll down until the last row with -4 is visible and then hold the Shift key down while you click on the row number and it will select all of the rows from the 2 to -4. -- Regards, OssieMac "Martin" wrote: I deal with a number of huge spreadsheets and need to remove all rows with the values 2 through -4 in col AE; first I sort AE in descending order, then manually find the first occurance of 2 in AE, then manually select rows until the first value occurance after -4. This may involve 100,000s of rows and is very time consuming, even using Page Down... Can anyone suggest a macro to to fully automate this .. I have tried recording a macro but it does not seem to handle handle the fact the first occurance of a 2 changes each time the spreadsheet is generated. Problems of a novice user, and thanks in advance for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Rows based on Column Critieria | Excel Discussion (Misc queries) | |||
Macro Help Needed: Comparing cell values and deleting rows | Excel Discussion (Misc queries) | |||
Can visual basics hide rows based on cell values? | Excel Discussion (Misc queries) | |||
Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Deleting rows based on a cell value | Excel Worksheet Functions |