I have a filter function on one 'SuperSheet', that pulls data from seven other sheets. If one of those sheets gets updated, it skews the rest of the cell values on the supersheet. How do I lock (for example) D8 to Average Voltage L-L(Figure 1) instead of having it move to Badbadbad(Figure 2) when one of the other sheets are updated?

Before Before

After After

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.