I am after some help, I've got a macro for searching multiple worksheets/books and print to Dashboard the results.
Only problem is it has to be exact matches. I am looking for help to make it look for partial, as several people will have access and not all know the correct names/id's
Many thanks for any help. I am new to this and got my macro from elsewhere.
Attached is the file that I got from someone else, just need to adapt it to partial search if possible?