Debra Dalgleish Question

V

VBA Noob

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
 
D

Debra Dalgleish

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.
 
V

VBA Noob

Thanks Debra


VBA Noob

Debra said:
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.
Click to expand...
 
V

VBA Noob

Hi Debra,

For some reason it doesn't see the dynamic ranges. Any thoughts what
could be wrong ??

Thanks

VBA Noob
 
D

Debra Dalgleish

What I described would work for dynamic ranges in the same workbook.
Perhaps yours are in different workbooks, so the technique doesn't work.

VBA said:
Hi Debra,

For some reason it doesn't see the dynamic ranges. Any thoughts what
could be wrong ??

Thanks

VBA Noob
Click to expand...
 
V

VBA Noob

Hi Debra,

That's exactly what the problem is

PS. Just got a copy of your book this morning and will look forward to
picking up some more pivot tips

VBA Noob
 
D

Debra Dalgleish

Thanks for buying a copy! I hope you find some new tips in it.

VBA said:
Hi Debra,

That's exactly what the problem is

PS. Just got a copy of your book this morning and will look forward to
picking up some more pivot tips

VBA Noob
Click to expand...
 
Top