Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi - I've got a stack of customer data that's been
extracted from a database in CSV format and then opened in Excel All's well apart from some of the accounts I dont need - these are one's that have no deatils in the "Bank" "Sort Code" "Account" columns. My question is how do I go about getting Excel to look at the blanks and automatically Delete them? So far my little knowledge allowed me to make the following if statement but it only tells me to physically "DELETE" non-bank customers... I want to know how I get to tell Excel to actually search for bloanks then delete.... if that makes sence!! HELP Ta Julia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to If Statement | Excel Discussion (Misc queries) | |||
If statement in macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
IF statement macro | Excel Programming | |||
Macro statement | Excel Programming |