table - lines variables for DB functions, charts.. etc..

with a vba macro I populated a table, the size of this table is variable in
each execute this macro.

and with this table I create pivot table, Database functions, but
How to use all resources with all data?

suggestions and examples
thanks

Marina

Hi Marina

Create a dynamic named range for your data.
Insert>Name>Define>Mydata Refers to =OFFSET($A$1,0,0,COUNTA(A:A),10)
The above example would create a range which contained as many rows as
are present in column A, and the would be 10 columns wide.
Change the formula as appropriate to your data location.

Then in the Pivot Table, where it asks for data range, enter =Mydata.

--
Regards

Roger Govier


"Marina Limeira" <marinalimeiraa@yahoo.com.br> wrote in message
news:%23843XDiHGHA.3984@TK2MSFTNGP14.phx.gbl...
>
> with a vba macro I populated a table, the size of this table is
> variable in
> each execute this macro.
>
> and with this table I create pivot table, Database functions, but
> How to use all resources with all data?
>
> suggestions and examples
> thanks
>
> Marina
>
>
>