On Jan 29, 12:49*am, joel wrote:
when you consolidate are you checking both use labels on Row and Column.
I usally write the code to consolidate when needed. *I try to post an
example tonight.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=174159

Microsoft Office Help

Joel,

Using excel 2003, just testing data consolidate for 6 worksheets of 12
months budget with all selection keys (ie row & column headers and
create link to source data) and post the result on new workbook shows
24 months data consolidation but it works fine for data consolidate on
2 or 3 worksheets of 12 months budget with the same selection keys,
now getting no confidence on using excel data consolidate function

Regards
Len