Hi guys, is there a way to use one sheet as a master database to pull from so I can output these results to another or multiple other sheets? I've tried VLOOKUP, INDEX, everything.
What I'm looking to do is have all of my categories in a specific section display the output of all of my results under certain headings. Is there any way to get this done with or without using macros? Almost need to pull from my master database and spit out the results on my display/print pages. I've been driving myself nuts trying to figure this out. Thanks!
Input
Output
What I'm looking to do is have all of my categories in a specific section display the output of all of my results under certain headings. Is there any way to get this done with or without using macros? Almost need to pull from my master database and spit out the results on my display/print pages. I've been driving myself nuts trying to figure this out. Thanks!
Input
Output