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
Highlighted
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
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies