Forum Discussion
How to best manage what should be one table, but across several worksheets?
Why don't you make a view of the data?
1. Highlight Data
2. Insert Table
3. Data > Existing Connections > Tables
4. Double Click on your table
5. Decide where to put the copy of the data (New Sheet Most Likely)
6. Sort the table the way you want
7. When additional data is added to the original source table. You can just go to Data > Refresh All and the table you have arranged the way you like will update accordingly.
If you don't need to sort but only need to filter or hide/unhide rows you can use the Custom View Option.
View > Custom View
Hi Matt!
The Existing Connections doesn't give me anything.
I dug around a little more, and I'm leaning more and more towards a single massive table, be it only for ease of use (can't expect our interns f.ex. to know how to use pivot tables or other arcane Excel things).
You will only see a Table section on the Existing Connections if you have a table object in your workbook. Once this is set up you would only need to teach interns to click the Refresh Button. Even better you can set the data to refresh on open. Then they never need to do anything and it manages itself...
Step 1:
Step 2:
Step 3:
