Forum Discussion
Automatically import data from one sheet into another
Sheet2 is intended to be a template which will dupilcated 30+ times. Each new sheet made from Sheet2 will have completely different data listed under "Specific Items". The "General items" list is required to be uniform across all those new sheets. As such, I want the General items to be on one sheet which, when updated, is transferred to all the 30+ sheets.
A few more questions:
When the special items sheets get created, are there any special items on there, or is it just the heading for special items under the list of general items?
After the 30 sheets have been created, do you need them updated from the General items sheet when a general item is added or changed?
IngeborgHawighorst When the new sheets are created from the template, the "Specific Items" list will be empty initially, so it will just be a heading with no content underneath. They will then be populated later. So each sheet will have completely different data under "Specific Items".
"General Items" will remain the only uniform data set across all the sheets created from the template (Sheet2) and must remain uniform as it is updated over time.
tomKG So, when the new sheets are created, wouldn't it make sense to use the General Items sheet as the template and just add a heading for Specific items below that?
Once the sheets have been created, updating with new values, making changes to existing values and inserting rows above the Specific items will be really, really difficult.
IngeborgHawighorst No because the General items will be slowly changing over time and the templates will be created over the course of many months. The 30th sheet may be made 6 months after the 1st sheet, but they will need to have uniform General items If I use the general items sheet as a template, the General items list will vary from sheet to sheet based on when it was duplicated.