Inherit rows of data from sheet1, and list in sheet2

**kernelsanders** · 07-14-2014, 01:34 PM

Current situation:
We're working with a workbook of roughly 20 spreadsheets, each containing hundreds of rows of data. Most of the data across the sheets is duplicate with only 1 or 2 lines different between each sheet.

Goal:
We'd like a way of listing a "base" sheet from which all the other "variant" sheets just inherit the rows of "base" data, and then list data specific to that sheet below what has been inherited. How can this be done?

Gen. Questions:
1) Is there a way to dynamically insert an entire sheet in another?
2) Do any of you have better ideas on how to go about this?

This data is being edited manually and we're looking at how to streamline this process in a short time frame.

Thanks in advance for your help

**mikeTRON** · 07-14-2014, 02:18 PM

I would say if you have 20 datasets that are identical I would suggest creating ONE dataset or ONE tab of DATA, then having multiple reports OFF that data. This completely removes the need to include the data in all 20 tabs, where the report you can build will automatically do so.

I would have one Aggregated Data tab then as many pivot tables as you need filtered appriorately.

**kernelsanders** · 11-07-2014, 05:13 PM

I started trying pivot tables, but since each datum has an odd structure and can span a varying number of lines in a worksheet.

We went with creating a base set of data in sheet1, and then the scripts parsing the data on sheetX would to identify when to include the base data from sheet1. Thanks for your earlier reply though.