Worksheets

[Guest]

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.

 

[Bob Phillips]

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)