Help needed on Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3129755%22%20slang%3D%22en-US%22%3EHelp%20needed%20on%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3129755%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20an%20excel%20sheet%20that%20has%20lots%20of%20tabs.%20One%20tab%20pulls%20data%20from%20another%20sheet%20and%20is%20filtered%20by%20colour%20to%20count%20a%20sum%20of%20the%20coloured%20boxes.%20i%20am%20after%20this%20sheet%20automatically%20applying%20the%20filters%20again%20after%20i%20change%20the%20data%20where%20is%20comes%20from.%20eg%20data%20comes%20from%20sheet%20named%20%22London%22%20and%20replicates%20and%20counts%20on%20a%20sheet%20called%20%22London%20Dash%22.%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20London%20dash%20do%20this%20when%20i%20change%20data%20in%20%22london%22%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3129755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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"? 

0 Replies