Hi Debra,

Can you confirm for me that you can't use Dynamic Data Source tip in a
named range with the Multiple Consolidation Ranges Pivots.

E.g =OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),7)

Also is the only way to join the tables to type in the sql field in MS
Query (From Memory so my be wrong)


SELECT *
FROM Range Name 1 Range Name 1
UNION ALL
SELECT *
FROM Range Name 2 Range Name 2

Thanks

VBA Noob