I am using Excel2007.I need to create dynamic range for pivot table. I have data in sheet1 data are coming from SQL Stored Procedure from SQL Server2008. For now range is e.g. A1: D190 however number of row will grow.
Pivot table has to be in Sheet2.As I am new to excel2007 can someone give me step by step instruction, how to do this.
I found this suggestion :
But I don’t know how to implement and where to put this.