Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Delete entire rows by selecting different text in column A
I have a database that exports data to excel where duplicate and specific
data is deleted using macros. My question is the data in column A uses multiple years of information. Example 2009 2 Man Fall Senior Team Beall 2009 2 Man Fall Senior Team Beeghly 2008 2 Man Fall Senior Team Berish 2009 2 Man Fall Senior Team Blohm 2008 2 Man Fall Senior Team Brander 2008 2 Man Fall Senior Team Brown Using the If function how do I either just use part of the cell, e.g. "Fall Senior" or use the entire cell e.g. 2008 2 Man Fall Senior Team but use a wild card character for the year e.g. 20?? 2 Man Fall Senior Team to delete the entire row? Any help would be appreciated. -- Doug Small Business Databases |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Delete entire rows by selecting different text in column A
You could use Like:
if ucase(mycell.value) like "*" & ucase("fall senior") & "*") then if ucase(mycell.value) like ucase("20?? 2 Man Fall Senior Team") then The asterisk represents 0 to lots of characters. The ? is a single character. or you could use instr(): if instr(1, mycell.value, "fall senior", vbtextcompare) 0 then Doug wrote: I have a database that exports data to excel where duplicate and specific data is deleted using macros. My question is the data in column A uses multiple years of information. Example 2009 2 Man Fall Senior Team Beall 2009 2 Man Fall Senior Team Beeghly 2008 2 Man Fall Senior Team Berish 2009 2 Man Fall Senior Team Blohm 2008 2 Man Fall Senior Team Brander 2008 2 Man Fall Senior Team Brown Using the If function how do I either just use part of the cell, e.g. "Fall Senior" or use the entire cell e.g. 2008 2 Man Fall Senior Team but use a wild card character for the year e.g. 20?? 2 Man Fall Senior Team to delete the entire row? Any help would be appreciated. -- Doug Small Business Databases -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Delete entire rows by selecting different text in colum
thanks Dave
either way works great -- Doug Small Business Databases "Dave Peterson" wrote: You could use Like: if ucase(mycell.value) like "*" & ucase("fall senior") & "*") then if ucase(mycell.value) like ucase("20?? 2 Man Fall Senior Team") then The asterisk represents 0 to lots of characters. The ? is a single character. or you could use instr(): if instr(1, mycell.value, "fall senior", vbtextcompare) 0 then Doug wrote: I have a database that exports data to excel where duplicate and specific data is deleted using macros. My question is the data in column A uses multiple years of information. Example 2009 2 Man Fall Senior Team Beall 2009 2 Man Fall Senior Team Beeghly 2008 2 Man Fall Senior Team Berish 2009 2 Man Fall Senior Team Blohm 2008 2 Man Fall Senior Team Brander 2008 2 Man Fall Senior Team Brown Using the If function how do I either just use part of the cell, e.g. "Fall Senior" or use the entire cell e.g. 2008 2 Man Fall Senior Team but use a wild card character for the year e.g. 20?? 2 Man Fall Senior Team to delete the entire row? Any help would be appreciated. -- Doug Small Business Databases -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
Keyboard shortcut or selecting entire column | Excel Worksheet Functions | |||
CANNOT DELETE AN ENTIRE COLUMN | Excel Discussion (Misc queries) | |||
Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
Delete all rows where Column A contains Text | Excel Worksheet Functions |