1

I have a workbook with multiple worksheets, very similar data of each sheet, columns are a=person, b=task, c=department, d=due date. On a separate sheet I was trying to display all the tasks associated to one person, myself steve in this example.

Can it be done?

Column Headers = Person, Task, Department, Due Date Sample Rows = Steve, Present critical paths for French & Mandrin online Academy, Academy, May 22-2015

pnuts
  • 58,317
  • 11
  • 87
  • 139
Stephen Ratcliffe
  • 11
  • 2
  • Can you provide some sample data? Like are all the tasks located on one sheet just multiple rows? Or are you wanting to search over all the sheets and grab all the tasks for that person? – chancea May 21 '15 at 20:17
  • Hi there, thanks chances (I realized my subject line needed some changes) yes I'd like to grab all the rows across multiple sheets for that one person. I bit like I would normally use a filter on a single sheet. – Stephen Ratcliffe May 21 '15 at 21:12
  • Check out Pivot tables, read this: https://support.office.com/en-ca/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 – chancea May 27 '15 at 20:42

1 Answers1

0

Can be achieved with a PivotTable (eg see) but frankly filtering to select Steve and moving and/or copy/pasting to suit seems just as easy, or easier. Though easier still of course may be to combine all sheets into one and use PTs, filtering, Subtotal and such like to view the data to suit. There is much more inherent versatility in one sheet of all data than in many sheets with some of the data each.

Community
  • 1
  • 1
pnuts
  • 58,317
  • 11
  • 87
  • 139