Hello everyone. This really has me stumped. I recently started handling data in Excel using structured tables. I believe it would useful to create a working dashboard for customer entry and sales data. I dropped my data in which included:
Opportunity Name
OWNER
Business Line...
Does anyone know how I can display all of that data with a certain field assiocated to it from another worksheet? Example, I want to display all of the projects with an "active" flag, owned by a certain person in my "dash board" sheet. I have a main data dump from our corporate system with ALL...