Forum Discussion
Adding information to different sheets.
I’m new to using sheets. If I add information to the sheet1 is it possible for it to automatically add The information to sheet 2? I am maintaining a very large database with addresses, phone, emai...
You should look at using a table and then using a connection to the table. This way you can use them to show different sorts. In order to accomplish this you can do the following:
1. Make your data a table (Ctrl + T)
2. Create the additional worksheets for your different sort views
3. Go to an additional worksheet
4. Data Tab > Get External Data Group > Existing Connections > Tables tab > select your table.
5. Now sort the table the way you would like it sorted
6. Repeat for additional views
7. Add Data to the original source table
8. Go to Data Tab > Refresh All
9. Now you can see that all of your tables were refreshed and the sorts you set up stay in place
I'm attaching an example file for your reference. Hope this helps.