View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Igor[_2_] Igor[_2_] is offline
external usenet poster
 
Posts: 6
Default Pivot table - consolidation range

Hi

There is a possibility in excel to add a pivot table for data from multiple
sources. At some point, when setting the pivot table with a wizard, there is
a listbox with all the sources. I need to somehow get the items from that
list, in other words, I need to get the list of all the sources the pivot
table retrieves data from?

How can I do that?

Kind regards
Igor M.