Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting rows conditional... help!!!
Is there a way to delete rows if they fit a condition?
For example: Sheet 1 contains all the names. Sheet 2 contains names I want to get rid of the whole row. Sheet 3 what I want to end up with. SHEET 1 A B C D SHEET 2 A B SHEET 3 C D Can anyone give me a step by step guide on how to do this please as I do not know a lot on excel or visual basic. Cheers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleting rows conditional... help!!!
Hi laandmc
See http://www.rondebruin.nl/delete.htm Read the infor below the first macro and use this in the macro If Not IsError(Application.Match(.Value, _ Array("jelle", "ron", "dave"), 0)) Then .EntireRow.Delete 'Or use this one with Application.Match if you want to check more values. 'in the cell. You can also use a range with the values to delete. 'Replace Array("jelle", "ron", "dave") with Sheets("Sheet1").Range("A1:A200") -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "laandmc" wrote in message ... Is there a way to delete rows if they fit a condition? For example: Sheet 1 contains all the names. Sheet 2 contains names I want to get rid of the whole row. Sheet 3 what I want to end up with. SHEET 1 A B C D SHEET 2 A B SHEET 3 C D Can anyone give me a step by step guide on how to do this please as I do not know a lot on excel or visual basic. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting rows | Excel Discussion (Misc queries) | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Deleting a conditional format | Excel Discussion (Misc queries) | |||
deleting a conditional format | Excel Discussion (Misc queries) |