Hi,

I have an excel sheet that is fully in English. This is used for producing many different types of reports, mostly with the use of slicers+pivot tables. However, I'd now need to produce reports where these tables are in French and in German. The issue here is that I'll need to translate on the final tables only (after all calculations are done) and as results change position with respect to different inputs IF formulas aren't really an option.

How to create a list of translation variables that are to be used in specific excel areas after the calculation takes place?

I've added an example as attachment. The final table to be translated is on top right side and neither the raw data headers nor pivot table should be changed (calculation would become way too heavy for my data set).

Thanks in advance for all your ideas.

Best,
Vasco

translate.xlsx