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!