Just offering some brief thoughts. "Consolidate" usually means to combine num
data (eg arithmetically sum up corrresponding nums) from a couple of places
in the same sheet or from identical ranges over several sheets. "Linking"
usually means to directly reproduce/reflect data from various places in the
book into a central place w/o any arithmetic operation. Check up Excel's help
for more info and examples.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"krangmummy" wrote:
Can someone explain the difference between linking data from separate
workbooks and consolidating data?

I am currently using Excel 2003.

Could you also give me some examples of when to use consolidation and when
it is more appropriate to link? (if that makes any sense)

Thanks ^^