Worksheets
is there a way to make worksheets in other worksheets/workbooks and then have
all of that inside another workbook. I need to create worksheets for 3 employees to record their work individually, for example. The information is entered into employee's worksheet then needs to be put into a separate form that combines the employee's worksheets collectively for a month's period. That then needs to be put into a form grouped by year. Is this possible to do or am I wishing for miracles??? Any help is greatly appreciated. |
Worksheets
The folding workbooks scenario that you describe is not possible, but it is
possible to reference another workbook from a workbook, so you could easily have a master workbook that pulls in the critical data and summarises that. For instance ='K:\My Documents\Spreadsheets\[Unique Entries.xls]Sheet1'!$A$4 is an example of referencing a cell in a closed workbook. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "KB-1" wrote in message ... is there a way to make worksheets in other worksheets/workbooks and then have all of that inside another workbook. I need to create worksheets for 3 employees to record their work individually, for example. The information is entered into employee's worksheet then needs to be put into a separate form that combines the employee's worksheets collectively for a month's period. That then needs to be put into a form grouped by year. Is this possible to do or am I wishing for miracles??? Any help is greatly appreciated. |
All times are GMT +1. The time now is 03:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com