Macro searching

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
448
Office Version
  1. 365
Platform
  1. Windows
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...
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,132,977
Messages
5,656,192
Members
418,289
Latest member
Kjohno

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top