Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Fast Search Entire Workbook Tutorial - Wildcard Search

0

Hello,

As the title suggests, I have successfully used the above tutorial to search multiple workbooks in Excel.

However I would like to know if there is a way to use a wildcard such as * in the search box please?

For example I currently have a list of product codes over seveal spreadsheets in a workbook but only want to search for product codes that begin with HB, I assume that to search for all product codes with HB, I would need to enter HB*

Does that make sense.

Thanks in advance

Dave

excelmacros-vba
posted by: DaveEastwood (rep: 2) on Mon Nov 1, 2021 at 9:52 am
Answer
Discuss

Answers

1
Selected Answer

Dave

Please try my previous answer(/file) on a similar question earlier this year, here Fast Search Multiple Workbooks with Wilcard.

If that works, please return here to select the Answer or comment.

posted by: John_Ru (rep: 6142) on Mon Nov 1, 2021 at 10:56 am
Discuss

Discussion

Thanks for the link John, it have soved my problem, my thanks for the quick response and help.

Dave
DaveEastwood (rep: 2) Nov 2, '21 at 6:37 am
NP Dave and thanks for selecting my Answer
John_Ru (rep: 6142) Nov 2, '21 at 6:41 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login