Forum Discussion
Is there a way to "copy" all information from a row to another sheet based on specific information?
I have one Master sheet and 6 bureau sheets. The Master sheet has 21 columns: Last name, first name, case#, SSN, Assigned Bureau, etc. The Assigned Bureau column has 6 different options (C100, E100,...
Hi Courtney,
Yes, that could be done through PivotTables. The only point is to apply correct layout to it. Where to place doesn't matter. Add to PivotTable all fields but Bureau which use as a filter.
Staying on PivotTable in ribbon Analyse->PivotTable Options select
confirm it
and new sheets will be generated for each value of the filter
To update all of them use RefreshAll
Sample file is attached.