Excel 2007 - Consolidation question
Hi, I have three worksheets, set up identically. I created a fourth
worksheet which was to capture the totals of the other three. To do this, I
used DataConsolidation and then put in the references to the sheets and
ranges. No problem there. Now I am changing figures in the first three
worksheets, but they are not filtering through to the consolidated sheets.
Why? Any help would be appreciated. Many thanks.
--
Trish
|