Create sub-sheets w/data populated from a master sheet

[Pgm_Mgr]

I feel like this question is very rudimentary however, I'm having trouble finding a good reference to what I'm looking for on google and YouTube.

I have a table that has approximately 30 columns of data and 250 rows of data, let's call this the master data sheet. I want to be able to tie the data on the master data sheet to subsequent sub-sheets but remove some of the columns to reflect different "views" essentially. But I want it so that when data is updated on the master data sheet it filters to the subsequent sheets no matter what columns are showing etc. Is this done by merely creating cell references? Is that the best way? I thought I could do this through pivot tables, but that wasn't working well... then I tried Lookup Tables and that didn't seem to do what I wanted.... please help.

My last question would be, once I get this set up correctly, can cells only be edited through the master data sheet, or is there a way to make it so that edits on the sub sheets transfer back to the master data sheet as well?

Thanks in advance.

Marty

[JeteMc]

Is all of the data of the same type or are the entries in Data 1 a list of Names or ID's to which the other columns relate?
Is the data in Data 2:Data 10 actually text or is it numeric?
If the answer to the above is Names/ID's and numeric, then perhaps the following will help.
1. Use Get & Transform to convert the master table into a row over row data table using the following advanced editor code:

Please Login or Register  to view this content.

Note that I had renamed Table 1 as tblMaster prior to utilizing Get & Transform (this is optional)
2. Produce a pivot table such as the one on Sheet 1 such that the data columns may be selected from the Data Type filter/sort button.
Let us know if you have any questions.

[Pgm_Mgr]

Thank you soooo much! This actually helped. Really appreciate it!

Marty

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.