If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro searching

Thread starter Dan Wilson
Start date Mar 23, 2021

Dan Wilson

Well-known Member

Mar 23, 2021

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.
Thanks,
Dan Wilson...