Hello, I have googled the snot out of this and can't come up with an answer. I need a code that will search through B5:B40 on Sheet1, sort alphabetically, and then copy only the names that start with the letters A-L and past them into Sheet2 starting at B5. Then copy all the names from Sheet1 that start with M-Z and past them into Sheet3 starting at B5 again. Please help.
Bookmarks