Forum Discussion
Automatically import data from one sheet into another
Hi tomKG ,
duplicating data is seldom a good idea and often not necessary. Why do you need the data in one sheet? And if you need it in one sheet, why have a separate sheet for data entry? Can't the General items be maintained in the sheet with the Specific items?
What should happen in your two sheet scenario when someone edits a General Item after it was already copied to the other sheet? It will be a major effort to keep the items in sync on both sheets, so looking into the bigger picture of what you would like to achieve may help find a better approach that may be different from what you are asking for in your question.
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.
