So I have a database with a bunch of companies in column A and several facts about each organization in the following columns. Some of those other columns are priority and stage.
I am trying to create a summary tab that has different sections where the top rows in the summary tab pulls in the top priority companies vertically with some of the key info in the columns next to the name. Its easy for me to pull in those additional columns with index match/vlookups once I pull in each company name but I am trying to automate the summary tab so the correct companies get pulled into the correct section in the summary tab (not all companies will be in the summary tab and they will be in a different order than the log).
Any ideas how to do this?
Bookmarks