Hi. I'm importing a excel file from excel 2003 into excel 2016 student. When I do this, I am going make a worksheet for each of the columns so that each of the sheets has the same information. I want to link each sheet so that when I add a row or change the data on any of the other rows it will change all the sheets.
It would be easier to maintain on one sheet, but I am making a catalog of the movies I have would like to be able pull them up in the different column order such as movie title, location, or movie type, and have them sorted in the respected order.
I think I would create PivotTables from the source data. Drag the columns you want in the order you want for each tab. After that, if you have updated your data simply click Refresh ALl on your data tab.
