Reports: Joining multiple sheets by column names
Let's see if I can ask this correctly.
I would like to have a report pull from 2 sheets.
Sheet A: Resource (Drop down of people in department), Department Name, Title
Sheet B: Project Plan (Possibly plans but lets stick to 1 sheet for now), with Assigned to , Status, etc
Assume I make the Resource and Assigned to the same column name.
I would like to pull the report to join these sheets so that I could have a nice summary of:
Resource, Department, Title, # of Tasks by Status
Every time I attempt this, the data for Department and Title have no information for Status, etc. The data for Status and etc have no information for Department and Title.
Still fairly new here, so maybe I am just missing something? Thanks in advance.