ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can this be done. (https://www.excelbanter.com/excel-discussion-misc-queries/139396-can-done.html)

Flinty

Can this be done.
 
Hi All,

At present we have a spreadsheet with individual sheets within the
"main-body" of the sheet. It is getting a bit unwieldy and cumbersome given
the number of sheets now involved (around 17).

The question is could you have a Sheet within a Sheet e.g. Main-body (File)
a sheet called (Flinty) and extra sheets within (Flinty)?

Any information would be greatly appreciated.

Regards.

JLGWhiz

Can this be done.
 
Hi Flinty,
Excel has a system called Workbooks and Worksheets. Workbooks are the main
files and worksheets are partititions within the main file. The worksheets
can be subdivided with Named Ranges, Tables and Charts. You can append
UserForms but they are not part of the worksheet per se. A lot of these
things are explained in tutorials that are aviailable free on the web. Just
Google "Microsoft Excel Tutorials".

"Flinty" wrote:

Hi All,

At present we have a spreadsheet with individual sheets within the
"main-body" of the sheet. It is getting a bit unwieldy and cumbersome given
the number of sheets now involved (around 17).

The question is could you have a Sheet within a Sheet e.g. Main-body (File)
a sheet called (Flinty) and extra sheets within (Flinty)?

Any information would be greatly appreciated.

Regards.


Dave Peterson

Can this be done.
 
How did you get individual sheets within the "main-body" of the sheet?

What does "main-body" mean?



Flinty wrote:

Hi All,

At present we have a spreadsheet with individual sheets within the
"main-body" of the sheet. It is getting a bit unwieldy and cumbersome given
the number of sheets now involved (around 17).

The question is could you have a Sheet within a Sheet e.g. Main-body (File)
a sheet called (Flinty) and extra sheets within (Flinty)?

Any information would be greatly appreciated.

Regards.


--

Dave Peterson


All times are GMT +1. The time now is 09:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com