Forum Discussion
How to return counts of text cells across multiple worksheets in same workbook?
I'm working in Excel 365. Windows environment. Working in the Excel app but will be posting to a shared drive for multi-user data entry. 38 worksheets, one for each office. What I need is to be...
I've copied all 9 office tables and VSTACKed columns [Date/Time Logged Here]:[Status:] of each dynamic table in the formula. Perhaps you can do the same for the remaining tables. It's actually repeating the same data for each table in the VSTACK part of the formula.
VSTACK(
Office1[[Date/Time Logged Here]:[Status:]];
Office2[[Date/Time Logged Here]:[Status:]];
Office3[[Date/Time Logged Here]:[Status:]];
Office4[[Date/Time Logged Here]:[Status:]];
Office5[[Date/Time Logged Here]:[Status:]];
office6[[Date/Time Logged Here]:[Status:]];
Office7[[Date/Time Logged Here]:[Status:]];
Office8[[Date/Time Logged Here]:[Status:]];
Office9[[Date/Time Logged Here]:[Status:]])In cell R2 of the result sheet you can enter a staff member's name to return all their records.
In your sample data i don't see information for the regions otherwise it should be possible to group certain offices into their regions.
Awesome! That will certainly help. I'll work with it and let you know how it goes. There is another solution above from Patrick2788 which is using PowerQuery to compile and use in Pivot Tables. I will explore that as well. Thank you very much! :)