Hi Steven,

Thanks for your information. I'll take a look to the files you mentioned.
Have a nice day.

Regards.

"steven1001" wrote:


Since you wish to use the data in a pivot table then you could use the
approach detailed in the link below.

http://www.contextures.com/excelfiles.html#Pivot

look for the paragragh saying..
"PT0007 - Multiple Consolidation Ranges -- Create a normal pivot table
from multiple ranges, by using MS Query to join the data. One sample
file contains the pivot table, the other contains the source data
tables. Contains macro to update connection. PivotMultConsolPivot.zip
11 kb PivotMultConsolProv.zip 6 kb 03-Oct-05"


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=556808