Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
consolidating data and linking data
Hi
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 ^^ |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
consolidating data and linking data
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 ^^ |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
consolidating data and linking data
Thanks Max, that is what I was looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating Data | Excel Worksheet Functions | |||
consolidating data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Worksheet Functions | |||
Consolidating data?? | Excel Worksheet Functions |