Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have an excel with several tables and they asked me to recreate something similar.
Each table has an "Lote de Inspección" with its respective analyzes.
I managed to recreate with a pivot table but within the table are all the inspection lots and the objective is to have several tables. Is it possible to create pivot tables automatically for each "Lote de Inspección"?
Greetings.
Hi,
I don't think you can do this automatically, but u can easily create copies and adjust those copies with set analysis on the [Lote de Inspección] field. But, my first question to end users would be, do they really need so many separate tables? Can't they do with 1 and select particular Lote de Inspección from a list box? Or maybe two (with alternate states) tables if they want to compare different Lote de Inspección?
Hope this helps.
Juraj