mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have inherited a huge financials file with hundreds of country P&L tabs which pull from a data table. These country tabs are then summarised by identically laid out region tabs using a basic sum function linking to the relevant cells on the country tabs
Eg. EMEA region tab cell A1 = Sum(France!a1,Germany!a1,Italy!a1)
Using this method if i was to add another country to EMEA it would be very cumbersome to update every formula to for example = Sum(France!a1,Germany!a1,Italy!a1,Denmark!a1)
Ive tried using 3DSUM and SUMPRODUCT methods but they slow the sheet down too much. Can any one think of a way to update the SUM functions easily for additional country tabs added to a region?
Thanks
Eg. EMEA region tab cell A1 = Sum(France!a1,Germany!a1,Italy!a1)
Using this method if i was to add another country to EMEA it would be very cumbersome to update every formula to for example = Sum(France!a1,Germany!a1,Italy!a1,Denmark!a1)
Ive tried using 3DSUM and SUMPRODUCT methods but they slow the sheet down too much. Can any one think of a way to update the SUM functions easily for additional country tabs added to a region?
Thanks