Hi,

Assume that I have 2 workbooks, WB1 and WB2. Assume that both workbooks are open at the same time.

WB1 is the output workbook and WB2 is the source of the data with the pivot tables. Note: WB2 has multiple sheets, each of which has multiple Pivot tables PTA, PTB PTC, PTD....... PT 'n'.

I want a formula in WB1, that retrieves data the first line of the rowfield data, in PTA, on Worksheet1 from WB2.


Thanks in advance.


AXl