Hi Steve

No, you will not see any formula, just the result.
If you need to refresh, then with the cursor in the first of the result
cells, just choose DataConsolidateOK.

It does work with multiple sheets also.
You just need to keep adding the ranges until you have the range from each
sheet entered, before you press OK.

--
Regards
Roger Govier



Roger--

I got it to work and will be very useful--interesting that I do not
see any trace of formula after I use the 'Consolidate" function. I
have tried to use "data consolidate" when working with multiple
worksheets that were identical in range layout but have not gotten it
to work--maybe your " written by John Walkenbach he does not mention
Data--Consolidate at all. Thanks again.

Steve G