- Feb 5, 2006
- Office Version
Good day all. I an running Excel out of Office 365 (updated) on Windows 10 Home. I have a worksheet that contains 8 Columns with 4500 Rows. One of the columns is titled Artists and another is titled Year. The Year Column contains a four-digit number from 1900 to 2021. The Artist Column starts with A-Z, a digit or a special character (?, "). I would like to have a Macro that can match for the first character of the Artist with a designated character and then match the Year with a supplied number. All matches are to be entered into a separate worksheet formatted to match the searched worksheet. I have tried several functions, but am not having any success. I am getting better with Macros, but not good enough. I appreciate any help.