Home

Copying and updating data in different sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-429500%22%20slang%3D%22en-US%22%3ECopying%20and%20updating%20data%20in%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-429500%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20sheet%20that%20is%20a%20master%20list%20of%20data%20with%20links%20to%20different%20sheets%20in%20one%20column.%20Each%20sheet%20has%20a%20section%20that%26nbsp%3Bis%20copied%20and%20linked%20to%20the%20master%20sheet.%20When%20I%20update%20data%20in%20the%20individual%20sheets%20it%20automatically%20updates%20in%20the%20master%20sheet.%3C%2FP%3E%3CP%3EThe%20only%20problem%20is%20if%20I%20have%20to%20add%20a%20row%20in%20the%20individual%20sheets%20it%20will%20not%20add%20this%20row%20in%20the%20master%20sheet.%20Is%20there%20something%20I%20can%20do%20to%20have%20this%20automated%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-429500%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-429673%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20updating%20data%20in%20different%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-429673%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20keep%20the%20%22original%22%20data%20in%20the%20master%20sheet%20and%20edit%20it%20there%2C%20rather%20than%20the%20other%20way%20around.%20Then%20you%20can%20use%20fucntions%20like%20INDEX%20and%20MATCH%20to%20pull%20the%20relevant%20information%20into%20the%20individual%20sheets%20from%20the%20master%20table.%20You%20should%20look%20at%20your%20individual%20sheets%20as%20%22just%20another%20view%22%20of%20your%20data.%20In%20fact%2C%20doing%20it%20this%20way%20may%20mean%20you%20only%20need%20one%20(flexible)%20individual%20sheet!%3C%2FLINGO-BODY%3E
a_head-1
Occasional Visitor

I have one sheet that is a master list of data with links to different sheets in one column. Each sheet has a section that is copied and linked to the master sheet. When I update data in the individual sheets it automatically updates in the master sheet.

The only problem is if I have to add a row in the individual sheets it will not add this row in the master sheet. Is there something I can do to have this automated?

1 Reply
I would suggest to keep the "original" data in the master sheet and edit it there, rather than the other way around. Then you can use fucntions like INDEX and MATCH to pull the relevant information into the individual sheets from the master table. You should look at your individual sheets as "just another view" of your data. In fact, doing it this way may mean you only need one (flexible) individual sheet!
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies