Hi all,
i have an excel sheet that has lots of tabs. One tab pulls data from another sheet and is filtered by colour to count a sum of the coloured boxes. i am after this sheet automatically applying the filters again after i change the data where is comes from. eg data comes from sheet named "London" and replicates and counts on a sheet called "London Dash".
Can London dash do this when i change data in "london"?
