Cross Sheet References
We have a data entry sheet where data is entered via forms and an overview sheet, that is an overview sheet with cross sheet references. Using sumif formulas, however this only works when you open and save the overview sheet, you can't get live data unless you open and save the overview. Any workaround to this?
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!