0

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

  • 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? No, not by using your existing systems. Adding information to linked data is a common problem. You need to think more creatively about either the data that you want to add, or an alternative to filtering. Without knowing more about the calculations that you do, I can't be more specific – Tedinoz Apr 5 at 9:17

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.