Home

automatically update referenced cells from one sheet to another in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-720107%22%20slang%3D%22en-US%22%3Eautomatically%20update%20referenced%20cells%20from%20one%20sheet%20to%20another%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAfter%20linking%20source%20%26amp%3B%20destination%20worksheet%2C%20if%20i%20insert%20a%20new%20row%20or%20column%20in%20the%20source%20worksheet%20how%20to%20get%20auto%20update%20in%20the%20destination%20worksheet%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-720107%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-720326%22%20slang%3D%22en-US%22%3ERe%3A%20automatically%20update%20referenced%20cells%20from%20one%20sheet%20to%20another%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-720326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366522%22%20target%3D%22_blank%22%3E%40EmilyLu%3C%2FA%3E%26nbsp%3BCan%20you%20explain%20in%20a%20bit%20more%20detail%20how%20you%20%22link%22%20the%20two%20sheets%3F%20Can%20you%20attach%20a%20sample%20file%3F%20Please%2C%20no%20confidential%20data%20and%20only%20a%20few%20rows%20to%20illustrate%20what%20you%20want%20to%20achieve.%3C%2FP%3E%3C%2FLINGO-BODY%3E
EmilyLu
Occasional Visitor

After linking source & destination worksheet, if i insert a new row or column in the source worksheet how to get auto update in the destination worksheet

1 Reply

@EmilyLu Can you explain in a bit more detail how you "link" the two sheets? Can you attach a sample file? Please, no confidential data and only a few rows to illustrate what you want to achieve.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies