Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
I'm having trouble linking one master file to mutiple (8) files. The master
file will collect information that has been entered in the other files and populate based on link criteria. Is this possible? Also, are there any compatability issues with using Drop-down menus created in Excel 2003 and trying to use them in Excel 2002? My menus will not populate correctly in 2002, but will in 2003. Thanks, anyone... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking Files
hi,
=SUM('K:\Excel\XCEL\[BBLZ.xls]Sheet1'!$G$1) =SUM('K:\Excel\XCEL\[BBLZ.xls]Sheet1'!$F$4:$F$14) you can use formulas like these. or from xl help (i typed "links") 1.Open both the workbook that will contain the link (called the destination file) and the workbook that contains the data you want to link to (called the source file) 2.In the destination workbook, click Save . 3.Select a cell or cells you want to link from. 4.If you are creating a new formula, type = (an equal sign). If you are entering the link elsewhere in the formula, type the operator or function that you want to precede the link. 5.On the Window menu, click the name of the source workbook, and then click the worksheet that contains the cells you want to link to. 6.Select the cells you want to link to. 7.Complete the formula. When you finish entering the formula, press ENTER Regards FSt1 "D J" wrote: I'm having trouble linking one master file to mutiple (8) files. The master file will collect information that has been entered in the other files and populate based on link criteria. Is this possible? Also, are there any compatability issues with using Drop-down menus created in Excel 2003 and trying to use them in Excel 2002? My menus will not populate correctly in 2002, but will in 2003. Thanks, anyone... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking PDF files | Excel Discussion (Misc queries) | |||
Linking between files | Excel Discussion (Misc queries) | |||
Linking multiple files | Links and Linking in Excel | |||
Linking Files | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) |