Hello,

I have a sheet that contains several thousand rows, each with 14 columns or so. I would like to have VBA scan the first char. of each cell in column C(some begin with text, some #'s) and sort them out to corresponding sheets alphabetically.
So if cell C3 said "SINA BERG", the entire row would be CUT and pasted into a sheet named "S". Cell C4, "SINA BERG2" would go into "S" also, but not overwrite the first entry. Cells beginning with numbers would go into a sheet named "#s".
If I could get code for it to actually work and just a couple of sheets then I can do the rest and I would be very grateful.

Thank you.