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? |
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. |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com