Forum Discussion
Filter data from table 1 on multiple sheets (Pivot table?)
I presume this is an extremely simple task but my Excel knowledge is limited. I have a table of Users I've exported from our AAD. We have multiple office locations so I want one sheet per offic...
You may create FILTER formulas to accomplish this task. Please see attached sample workbook.
This is good to know Patrick. However, I don't see that this is dynamic in that a change on 'Open' is reflected on 'Live or Hold'. I'm looking for a way to update data on one sheet to reflect on all sheets.