View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trish Trish is offline
external usenet poster
 
Posts: 66
Default 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