Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Needed - new user
Hello,
Please help me to write a code to accomplish the following: ..I have a list of account numbers listed in column A (starting from the second row or A2) ..I need the macro to go down the list (while there is still data) and determine if the account numbers are valid (against the list of invalid account numbers) ..And if it finds the invalid account number it should delete the entire row Of course I can determine the invalid accounts by using the VLookUp function and then manually delete the rows but it would be great if it can be down automatically (via macro). Please help and thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Forms - Tips needed to get started | Excel Discussion (Misc queries) | |||
User Forms - Tip needed to get started | Excel Discussion (Misc queries) | |||
User-friendly lookup solutions needed | Excel Discussion (Misc queries) | |||
user checklist formula needed XP | New Users to Excel | |||
code needed | Excel Programming |