Offset Table and Pivot Table
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
|