Home

I want to automatically update linked sheets, when rows are added to source sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-455321%22%20slang%3D%22en-US%22%3EI%20want%20to%20automatically%20update%20linked%20sheets%2C%20when%20rows%20are%20added%20to%20source%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455321%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20basically%20I%20have%20Sheet1%20set%20up%20with%20all%20data%20in%20it.%20This%20data%20is%20updated%20and%20new%20names%20added%20month%20to%20month.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20sheet2%20to%20only%20show%20names%20with%20an%20%22a%22%20next%20to%20them.%20So%20I've%20copied%20data%20from%20sheet%201%2C%20created%20a%20formula%20to%20only%20display%20%22a%22s%2C%20and%20will%20then%20put%20a%20filter%20on%20the%20data%20(I%20haven't%20shown%20all%20the%20steps%20for%20the%20filter%20on%20the%20screenshots).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20that%20when%20I%20come%20to%20add%20rows%20into%20sheet%201%2C%20it%20then%20throws%20all%20my%20formulas%20below%20that%20row%20in%20sheet%20two%20off.%20Is%20there%20a%20way%20that%20I%20can%20get%20sheet2%20to%20automatically%20update%2C%20as%20I%20update%20data%20in%20sheet1%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%20I%20only%20want%20to%20ever%20be%20making%20changes%20on%20sheet1%2C%20once%20this%20is%20set%20up!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20that%20makes%20sense!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-455321%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
YasminR
Occasional Visitor

So basically I have Sheet1 set up with all data in it. This data is updated and new names added month to month. 

 

I want sheet2 to only show names with an "a" next to them. So I've copied data from sheet 1, created a formula to only display "a"s, and will then put a filter on the data (I haven't shown all the steps for the filter on the screenshots).

 

My issue is that when I come to add rows into sheet 1, it then throws all my formulas below that row in sheet two off. Is there a way that I can get sheet2 to automatically update, as I update data in sheet1?

 

Ideally I only want to ever be making changes on sheet1, once this is set up!

I hope that makes sense!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies