linking sheets in different workbooks
Posted by Greg on January 11, 2001 10:35 AM
Is it possible to link an entire sheet to another sheet in a totally different workbook. Example: Job info in c:\jobinfo and have a copy on the server u:\Jobinfousers. What I am trying to do is make the workbook on the server a mirror image of a couple different workbooks. I have job workbooks that have up to 20 sheets and one of those sheets is a summary page. I want to put the summary page from each of the jobs onto one spreadsheet on the user drive so others can look at that instead of the main spreadsheet I work with. Is it possible?