Offset Table and Pivot Table

[ubns]

Hi,



I have lot of pivot tables and want to use the offset function.

So I have two queries here:

1) Lets say I have table from a1:c:1000. I want to use offset function in this so that as soon as I have some data in the row 1001 it includes that in the table range and;

2) Also update the PIVOT Table data source.

Is it possible? Can you please tell me what I am suppose to enter in the offset named range to make the above possible.

Thanks

Regards

Umesh Banga