Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to have two different sheets work in one document?
Is there a way to which I can have a master sheet in one folder and have
multiple files imputing information into the master sheet? Here is the trick I want to know. Can the master be updated by these files with out myself transferring the data? and to that can the files be located in different areas (ie. master is located in C: drive, and the other files be in D: drive on some one elses computer). Does that make sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to have two different sheets work in one document?
allie wrote: Is there a way to which I can have a master sheet in one folder and have multiple files imputing information into the master sheet? Here is the trick I want to know. Can the master be updated by these files with out myself transferring the data? and to that can the files be located in different areas (ie. master is located in C: drive, and the other files be in D: drive on some one elses computer). Does that make sense? Something like this ? ='P:\TEMP\[myfile.xls]sheet1'!$C$6 This is entered on your PC, assuming P\TEMP\myfile.xls is on the network. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print page 1 of all work sheets?? | Excel Discussion (Misc queries) | |||
formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
adding cells in different work sheets | Excel Discussion (Misc queries) | |||
navigational keys in protected sheets | Excel Discussion (Misc queries) | |||
How do I combine several sheets into one document in Excel? | Excel Discussion (Misc queries) |