| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
can I put a multiple worksheets within a worksheet(s) in a spreads
Example: If I have a spreadsheet named Linda, and it has 3 worksheets in it,
named Julie, Bob, and Laura, can I put three more spreadsheets under the Julie spreadsheet? |
|
#2
|
|||
|
|||
|
Quinn111,
You can have many worksheets, not just three in a workbook, but all these can only be on one level. You could have another workbook named Julie which you open (using code) from the Julie sheet in Linda. This will give the appearance of different levels of worksheet. Henry "quinn111" wrote in message ... Example: If I have a spreadsheet named Linda, and it has 3 worksheets in it, named Julie, Bob, and Laura, can I put three more spreadsheets under the Julie spreadsheet? |
|
#3
|
|||
|
|||
|
quinn
Not clear on what you mean by spreadsheet and worksheets. An Excel file is termed a "Workbook". A Workbook can be comprised of multiple "Worksheets". If Julie, Bob and Laura are Worksheets in a Workbook(Linda) that is as far down as you can go. Post back with more speific. Perhaps someone can devise a work-around. Gord Dibben Excel MVP On Thu, 28 Jul 2005 12:06:05 -0700, "quinn111" wrote: Example: If I have a spreadsheet named Linda, and it has 3 worksheets in it, named Julie, Bob, and Laura, can I put three more spreadsheets under the Julie spreadsheet? |
|
#4
|
|||
|
|||
|
"Henry" wrote: Quinn111, You can have many worksheets, not just three in a workbook, but all these can only be on one level. You could have another workbook named Julie which you open (using code) from the Julie sheet in Linda. This will give the appearance of different levels of worksheet. Henry "quinn111" wrote in message ... Example: If I have a spreadsheet named Linda, and it has 3 worksheets in it, named Julie, Bob, and Laura, can I put three more spreadsheets under the Julie spreadsheet? |
|
#5
|
|||
|
|||
|
Henry - Can you tell me how to do this?
"Henry" wrote: Quinn111, You can have many worksheets, not just three in a workbook, but all these can only be on one level. You could have another workbook named Julie which you open (using code) from the Julie sheet in Linda. This will give the appearance of different levels of worksheet. Henry "quinn111" wrote in message ... Example: If I have a spreadsheet named Linda, and it has 3 worksheets in it, named Julie, Bob, and Laura, can I put three more spreadsheets under the Julie spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
| Putting data from multiple worksheets into one | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
| How to print multiple worksheets in one workbook on the same page. | Excel Discussion (Misc queries) | |||
Linear Mode
