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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies