Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sheet on which I import data from an external source. After
importing data, I need something to remove complete rows that match a specific criteria. For example: I have in Column D a Date and in column E an EmployeeName and in column F and OrderNumber. after my import, I need some vba that runs through my data quickly to remove all existing rows that have the same Date, the same EmployeeName and an empty OrderNumber. For example D E F row 50) 17-08-2007 Mark 12345 row 60) 17-08-2007 Mark row 62) 17-08-2007 John In this case, only row 60 should be removed Thank you very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete duplicate rows, keep one | Excel Discussion (Misc queries) | |||
filtering out rows with duplicate information | Excel Discussion (Misc queries) | |||
Delete Duplicate rows | Excel Programming | |||
merging information from partial duplicate rows | Excel Discussion (Misc queries) | |||
delete duplicate rows | Excel Programming |