Hi everybody

I am working with macros which Refresh the Pivot Table, automatically. Everything is working fine except one real problem, as below:

When the newer rows are added to the worksheet, Refreshing the Pivot Table does not include those added rows in the Pivot Table, automatically, unless I do it manually. Extending the Range manually kills the whole purpose of the macros.

Would a wizard help me getting around this problem!

Also, how to find the Pivot Table name to reference it. At the moment, I am using FOR loop to hit any Pivot Table available on the sheet.

Any expert help will be highly appreciated.

Regards,