Duplicate Tables

[itsgrady]

I have a table on one spreadsheet that I would like to make an exact copy to other spreadsheets. If I make changes on the main spreadsheet it would make updates on the copies.

I have three categories. Small, Medium, and Large stored in the B column on the main spreadsheet. My boss would like to have the main spreadsheet with all three categories and a separate spreadsheet for each of the three categories. This is completely against my suggestion to him. I showed him how you get to the data from one spreadsheet, but he still would like to have them separated.

To cut down on data entry, I would like to only update the main spreadsheet. In needs to be in a table formate that can be sorted on each spreadsheet.

Spreadsheets:
Small
Medium
Large
Main

 

[MARK858]

As you are using tables I'd use power query (get and transform), you can filter the information and sort it in the one query easily

 

[MountainFog]

Two options:
1) The filter function. =FILTER(). This would allow you to filter by Small, Medium, and Large on each of the respective tabs. Any change made on the main table would automatically update on each of the tabs. The downside to this is that it creates an array formula where the output cannot be edited without cutting and pasting as values.

2) PowerQuery. Get & Transform Data on the data ribbon. You can easily filter into three seperate tables and load them onto their respective spreadsheets. The downside to this is that you become dependent on the Refresh All button in the data ribbon. You could also have the table join to itself where any changes that are made on the small medium and large tabs are reflected in the main table. This depends on where you want the changes to be made.

 

[itsgrady]

Two options:
1) The filter function. =FILTER(). This would allow you to filter by Small, Medium, and Large on each of the respective tabs. Any change made on the main table would automatically update on each of the tabs. The downside to this is that it creates an array formula where the output cannot be edited without cutting and pasting as values.

2) PowerQuery. Get & Transform Data on the data ribbon. You can easily filter into three seperate tables and load them onto their respective spreadsheets. The downside to this is that you become dependent on the Refresh All button in the data ribbon. You could also have the table join to itself where any changes that are made on the small medium and large tabs are reflected in the main table. This depends on where you want the changes to be made.

Two options:
1) The filter function. =FILTER(). This would allow you to filter by Small, Medium, and Large on each of the respective tabs. Any change made on the main table would automatically update on each of the tabs. The downside to this is that it creates an array formula where the output cannot be edited without cutting and pasting as values.

2) PowerQuery. Get & Transform Data on the data ribbon. You can easily filter into three seperate tables and load them onto their respective spreadsheets. The downside to this is that you become dependent on the Refresh All button in the data ribbon. You could also have the table join to itself where any changes that are made on the small medium and large tabs are reflected in the main table. This depends on where you want the changes to be made.

Thanks for the help. Appreciate the good information. I think I will try the filter formula.