View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Linking multiple workbooks together

It's exactly like linking from one workbook into one other, you just use more
workbooks! Is that enough help, or do you need more specifics?

On the off chance that you've mixed 'worksheets' with 'workbooks', I'll go
through it:
you have three data workbooks:
data1.xls
data2.xls
data3.xls
, and a summary workbook named summary.xls

Open all of them and then go into the summary.xls file and where you want a
reference from any one of the others, click in a cell and type the = symbol
to start a formula, then choose the other workbook, the sheet in it that you
need, and the cell within that sheet you need. Press the [Enter] key and the
link is established. Repeat as required for other references into the other
data#.xls files.

"yakdog" wrote:

Excel 2003. I have three works with data in them and would like to summarize
the data in a fourth workbook. I know how to link two workbooks together, but
not how to link multiple workbooks together.