Need help with Excel

[Walz_Label]

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.

Bldg	Area	Cord	Room	Exist	TYPE
FR	KIT	C01A01A01	C		H
FR	KIT	C01A01A02	C		H
FR	KIT	C01A01A03	C		H
FR	KIT	C01A02A01	C		H
FR	KIT	C01A02A02	C		H
FR	KIT	C01A02A03	C		H
FR	KIT	C01A03A01	C		R
FR	KIT	C01A03A02	C		R
FR	KIT	C01A03A03	C		R
FR	KIT	C01A03B01	C		R
FR	KIT	C01A03B02	C		R
FR	KIT	C01A03B03	C		R
FR	KIT	C01A03C01	C		R
FR	KIT	C01A03C02	C		R
FR	KIT	C01A03C03	C		R
FR	KIT	C01A03D01	C		R
FR	KIT	C01A03D02	C		R
FR	KIT	C01A03D03	C		R
FR	KIT	C01A03E01	C		R
FR	KIT	C01A03E02	C		R
FR	KIT	C01A03E03	C		R

[#2]

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