Hello Community,
I have this project where I have different tables with data in them and would like to summarize them in one table.
What would be the best way to achieve this and make the solution as robust as possible?
Key elements that are good to know.
1) Those tables are manually fed.
2) sometimes cells will have OK or N/A entered in them (again manually)
3) Every week they are deleted and replaced with a "virgin template" with different dates. Therefore the "summarized" table should continue to work without manipulating the formulas.
4) some cells will have sometime entries such as "3 + 2 ch" // Number mixed with text. - This could be hard to sum up. I might have to have an entry clerk change the way they input such information if the solution is too hard to implement.
5) finally, the "summarized" table should sum up only tables that are included in the defined dates.
Maybe some of the above is too hard to put in place, maybe not.
Thanks for your guidance
Claude
I have this project where I have different tables with data in them and would like to summarize them in one table.
What would be the best way to achieve this and make the solution as robust as possible?
Key elements that are good to know.
1) Those tables are manually fed.
2) sometimes cells will have OK or N/A entered in them (again manually)
3) Every week they are deleted and replaced with a "virgin template" with different dates. Therefore the "summarized" table should continue to work without manipulating the formulas.
4) some cells will have sometime entries such as "3 + 2 ch" // Number mixed with text. - This could be hard to sum up. I might have to have an entry clerk change the way they input such information if the solution is too hard to implement.
5) finally, the "summarized" table should sum up only tables that are included in the defined dates.
Maybe some of the above is too hard to put in place, maybe not.
Thanks for your guidance
Claude
