Hello. I've been trying to make myself a program to help me at work. I need a macro for searching in multiple excel files by a name that I input, and return me some of the values (not everything) from the other columns related to that name. I've created a form in excel, and I took the vba from this video:
Fast Search Multiple Excel Workbooks using a File Picker Window - YouTube
Can someone help me adjust it? I really need it for my job and I can't figure it out. Also, when I click the search button, it only pops up the browse files window, and after it's closed, it erases everything outside the form.