I have written a macro to divide a large spreadsheet into 5 smaller ones based on single character in one of the columns. One of the letters only appears on every other report which causes the macro to crash if it doesn't find the letter.
Is there any way to have Macro5 run only if the letter K is found in a cell in a specified column? I have tried and tried but cannot figure out how to get the macro to read a character in the cell - only a number.

Any help would be greatly appreciated!!!!!