I am trying to build a dynamic table that changes based off of what you select in a drop down but it pulls data from different tabs.
I can make it work when it is just looking at 1 tab but I would have multiple people populating their own tables on their own tabs so I want the home page to show me their data if I select their name and a specific date range from 2 drop downs.
The first picture is my home page and the next 2 are examples of what people may populate it with.
Please help!
I can make it work when it is just looking at 1 tab but I would have multiple people populating their own tables on their own tabs so I want the home page to show me their data if I select their name and a specific date range from 2 drop downs.
The first picture is my home page and the next 2 are examples of what people may populate it with.
Please help!