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

[Marina Limeira]

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

 

[Roger Govier]

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.