Thread: [Solved] Offset Table and Pivot Table
View Single Post
 
Old 04-16-2015, 03:47 PM
ubns ubns is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: Apr 2012
Posts: 177
ubns is on a distinguished road
Default 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
Reply With Quote