Hi,

Consolidate function is useful for budgetary consolidation purpose
However, if there are 12 worksheets to be consolidated, then
consolidate function is unable to call back and consolidate say 45
worksheets as it has reached the max limit of consolidation ( ie 12
sheets )
In this case, is there any options/alternatives available either on
excel function or excel vba to solve this problem ?


Thanks & Regards
Len

Can you just run cosolidate on 12 sheets at a time. I have written very
simple macros (about 30 lines) that can consolidate unlimited number of
sheets. using the column headers and row headers as keys.


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

Microsoft Office Help

On Jan 28, 7:18*pm, joel wrote:
Can you just run cosolidate on 12 sheets at a time. *I have written very
simple macros (about 30 lines) that can consolidate unlimited number of
sheets. using the column headers and row headers as keys.

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

Microsoft Office Help

Hi Joel,

Using column & row headers and create link to source data as keys, if
I were to run consolidate for 12 months budget on several times ( ie 7
times for different groups of worksheets ) and then consolidate again
on overall, the results show 25 months including column totals instead
of 12 months result,


Thanks for your help

Regards
Len

I assume you are running 2007 (I only have 2003). I suspect you are
using add instead of a merge. Not sure because I haven't run
consolidate on 2007.


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

Microsoft Office Help

On Jan 28, 10:38*pm, joel wrote:
I assume you are running 2007 (I only have 2003). *I suspect you are
using add instead of a merge. *Not sure because I haven't run
consolidate on 2007.

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

Microsoft Office Help

Both excel version 2003 & 2007 post the same result ( ie In office I
run data consolidate using excel 2007 and now at home using excel
2003 )
Further, both version do not have merge worksheet option ( ie only add
or delete option )

Regards
Len

On Jan 28, 11:39*pm, Len wrote:
On Jan 28, 10:38*pm, joel wrote:

I assume you are running 2007 (I only have 2003). *I suspect you are
using add instead of a merge. *Not sure because I haven't run
consolidate on 2007.

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

Microsoft Office Help

Both excel version 2003 & 2007 post the same result ( ie In office I
run data consolidate using excel 2007 and now at home using excel
2003 )
Further, both version do not have merge worksheet option ( ie only add
or delete option )

Regards
Len

Joel, it will great if you could share your excel vba codes to run
data consolidate on unlimited number of worksheets with selection keys
of row & column header, create link to source data

Thanks & Regards
Len