Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
connecting multiple work sheets
Hi the
Can anyone please help me out here? Suppose I have many different files (with detailed info) and I have one main summary file that draw results from these individual files. How can I connect these individual files with the main file? i.e, when I make changes in any one of the individual files, the changes will reflect in the main file as well? Any suggestions will be greatly appreciated! Thanks.. fyon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
connecting multiple work sheets
What you are describing is linked workbooks.
Ensure that one of the individual workbooks are open and that you can see both the summary and individual workbooks on the screen at the same time. Press = then click a cell value in the individual workbook. The formula then looks something like: =[Data2004.xls]Sheet1!$A$1 -- Rob van Gelder - http://www.vangelder.co.nz/excel "fyon" wrote in message ... Hi the Can anyone please help me out here? Suppose I have many different files (with detailed info) and I have one main summary file that draw results from these individual files. How can I connect these individual files with the main file? i.e, when I make changes in any one of the individual files, the changes will reflect in the main file as well? Any suggestions will be greatly appreciated! Thanks.. fyon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to print multiple work sheets using vba | Excel Discussion (Misc queries) | |||
how to sum cells from multiple work sheets | Excel Worksheet Functions | |||
Unhide multiple work sheets at once | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Multiple Work Sheets | Excel Worksheet Functions |