Home

Need help with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-428600%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-428600%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20some%20help%20with%20a%20function%20or%20a%20VBA%20script.%26nbsp%3B%20Essential%20I%20want%20to%20see%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%207th%20character%20is%20the%20letter%20%22a%22%20or%20%22b%22%20in%20column%20C%20then%20copy%20entire%20row%20and%20paste%20in%20sheet2.%3C%2FP%3E%3CP%3Esample%20data%20below.%26nbsp%3B%20Column%20C%20is%20%22Cord%22%26nbsp%3B%20I%20want%20to%20separate%20(filter)%20if%20the%20the%20data%20in%20the%20column%20cord%20contains%20the%20letter%20A%20or%20B%20then%20take%20the%20entire%20row%20and%20place%20in%20a%20new%20sheet.%26nbsp%3B%20The%20character%20length%20will%20always%20remain%20the%20same.%20I%20have%20over%2015%2C000%20lines%20that%20need%20to%20be%20separated%20into%20corresponding%20sheets%20based%20on%20what%20the%207th%20character%20is.%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EBldg%3C%2FTD%3E%3CTD%3EArea%3C%2FTD%3E%3CTD%3ECord%3C%2FTD%3E%3CTD%3ERoom%3C%2FTD%3E%3CTD%3EExist%3C%2FTD%3E%3CTD%3ETYPE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A01A01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A01A02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A01A03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A02A01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A02A02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A02A03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EH%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03A01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03A02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03A03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03B01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03B02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03B03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03C01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03C02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03C03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03D01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03D02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03D03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03E01%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03E02%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EFR%3C%2FTD%3E%3CTD%3EKIT%3C%2FTD%3E%3CTD%3EC01A03E03%3C%2FTD%3E%3CTD%3EC%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ER%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-428600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-429000%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-429000%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20able%20to%20use%20a%20filter%20function%20using%20contains%20%3F%3F%3F%3F%3F%3FA%3F%3F%20or%20%3F%3F%3F%3F%3F%3FB%3F%3F%20then%20the%20results%2C%20I%20just%20copied%20the%20entire%20sheet%20of%20the%20results%20and%20pasted%20in%20new%20sheet!%26nbsp%3B%20Worked%20like%20a%20charm.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318569%22%20target%3D%22_blank%22%3E%40Walz_Label%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Walz_Label
New Contributor

I need some help with a function or a VBA script.  Essential I want to see:

 

If the 7th character is the letter "a" or "b" in column C then copy entire row and paste in sheet2.

sample data below.  Column C is "Cord"  I want to separate (filter) if the the data in the column cord contains the letter A or B then take the entire row and place in a new sheet.  The character length will always remain the same. I have over 15,000 lines that need to be separated into corresponding sheets based on what the 7th character is.

BldgAreaCordRoomExistTYPE
FRKITC01A01A01C H
FRKITC01A01A02C H
FRKITC01A01A03C H
FRKITC01A02A01C H
FRKITC01A02A02C H
FRKITC01A02A03C H
FRKITC01A03A01C R
FRKITC01A03A02C R
FRKITC01A03A03C R
FRKITC01A03B01C R
FRKITC01A03B02C R
FRKITC01A03B03C R
FRKITC01A03C01C R
FRKITC01A03C02C R
FRKITC01A03C03C R
FRKITC01A03D01C R
FRKITC01A03D02C R
FRKITC01A03D03C R
FRKITC01A03E01C R
FRKITC01A03E02C R
FRKITC01A03E03C R

 

1 Reply

I was able to use a filter function using contains ??????A?? or ??????B?? then the results, I just copied the entire sheet of the results and pasted in new sheet!  Worked like a charm. @Walz_Label 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies