PPRuNe Forums - View Single Post - Pivot Table
Thread
:
Pivot Table
View Single Post
18th Aug 2012, 06:51
#
3
(
permalink
)
Bushfiva
Hippopotomonstrosesquipidelian title
Join Date: Oct 2006
Location: is everything
Posts: 1,826
Likes: 0
Received 0 Likes on 0 Posts
In the pivotchart wizard, select "multiple consolidation ranges" when asked "where are the worksheet ranges you wish to consolidate". You can then select ranges in different spreadsheets. The feature has changed names a couple of times.
Reply
Bushfiva
View Public Profile
Find More Posts by Bushfiva