You can create dynamic named ranges using that type of formula, then use
those names as the multiple consolidation ranges.

There may be other techniques to join the tables, but that's one that
I've used.

VBA Noob wrote:
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



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html