kurtkaufman
New Member
- Joined
- Sep 26, 2016
- Messages
- 4
Hello,
I'm working on simplifying the process of consolidating sales data. Each division (let's say A,B, and C) sells products through dealers. All of the divisions sell through the same dealers, but the dealers are always changing monthly (being added or removed).
Each month I send out templates to the divisions with updated dealers (this is done manually by adding and removing rows). Then I take all of the templates, and their numbers are pulled into a consolidation file. Whenever rows are added or deleted, I have to go into the consolidation file and change the referenced rows.
I wanted to make all of the templates into tables, and then use structured referencing to quickly and easily consolidate data into the consolidation file, but I'm having trouble.
This is what I tried, but could not get it to work...
=sum('[A.xlsx]2017'!TableA[Full Year],'[B.xlsx]2017'!TableB[Full Year]...) and so on
Suggestions would be greatly appreciated!
I'm working on simplifying the process of consolidating sales data. Each division (let's say A,B, and C) sells products through dealers. All of the divisions sell through the same dealers, but the dealers are always changing monthly (being added or removed).
Each month I send out templates to the divisions with updated dealers (this is done manually by adding and removing rows). Then I take all of the templates, and their numbers are pulled into a consolidation file. Whenever rows are added or deleted, I have to go into the consolidation file and change the referenced rows.
I wanted to make all of the templates into tables, and then use structured referencing to quickly and easily consolidate data into the consolidation file, but I'm having trouble.
This is what I tried, but could not get it to work...
=sum('[A.xlsx]2017'!TableA[Full Year],'[B.xlsx]2017'!TableB[Full Year]...) and so on
Suggestions would be greatly appreciated!