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.