If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|