Forum Discussion
Automatically import data from one sheet into another
I have 2 sheets within the same workbook. Sheet1 contains a list of "General Items". Sheet2 contains a list of "All Items" which includes the general items list.
I am wanting Sheet2 to grab all the items listed under "General Items" in Sheet1 and automatically add them to Sheet2 under a heading. Further to this, when a new row is added to "General Items" in Sheet1, I need this to automatically update Sheet2 to include that new row and data pushing all data below down as it does so.
Basically, anything added to the list in Sheet1 is automatically sent to a specific spot in Sheet2 (ideally copying formatting also).
How can this be done?
7 Replies
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?
