Hello guys.
i made a sort of database in excel.
in there is information about persons name , number, experience, function etc.
now i wonder is it possible when i create a second file to say go find everyone in that worksheet with that function and that experience and show those names in this new worksheet.i know there is a filter button but its still not the fastest way especially if you have lots of filters.
i heard macro's could help but i dont know yet how they work so i hope someone could help me out ?
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.)
Macro's
0
Answers
0
There are a lot of things that you can do and they usually do involve macros, here are some resources to checkout:
- Idiot-Proof Forms in Excel - this is one of our premium courses that will take you through every single step needed to go from a blank worksheet to a fully functioning data base type setup in Excel that lets you input, search for, and delete records. I think that this would work very well in your situation.
- Vlookup that Searches the Entire Workbook
- Vlookup to Return All Matching Results
- Vlookup Macro to Return All Matching Results and Stack them with Previous Results
I think that the premium course is your best option, but the other links provide insight into other ways to do what you're trying to do.