View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default Dynamic Pivot Table source

Hello all,

I haven't tried this yet, but I was wondering, when creating a pivot table
based on data in the current workbook, if the source range can be dynamic
using the OFFSET() and COUNT(A)() functions.

Thanks for any help anyone can provide,

Conan Kelly