I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on.
What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned in one place; would I be better off with Pivot tables, or a query?
What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned in one place; would I be better off with Pivot tables, or a query?
