Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Define list of worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |