ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tabs Inside of a worksheet (https://www.excelbanter.com/excel-worksheet-functions/6955-tabs-inside-worksheet.html)

havocdragon

Tabs Inside of a worksheet
 
Hello all.

This is a shot in the dark, and I'll see if I can explain what I am talking
about =).
I wan't to add some tab functinality to a range of cells, so that lets say I
have 10 sources of info but I dont want it to take up 2 pages thats hard to
read, but it still needs to be in the middle of some information. So lets say
I have A10 through J20 that has infomation in it on one tab, then I would
like to click another tab, and have A10 through J20 to display some different
information. Basically the samething as the sheet tabs, but within a small
range instead of a workbook.

Is this possible? Or have I smoked too much crack this time?

LanceB

Looking through the smoke from the crack, it appears you might want to look
at pivot tables, but I'm not sure, crack being what iit is.

Lance

"havocdragon" wrote:

Hello all.

This is a shot in the dark, and I'll see if I can explain what I am talking
about =).
I wan't to add some tab functinality to a range of cells, so that lets say I
have 10 sources of info but I dont want it to take up 2 pages thats hard to
read, but it still needs to be in the middle of some information. So lets say
I have A10 through J20 that has infomation in it on one tab, then I would
like to click another tab, and have A10 through J20 to display some different
information. Basically the samething as the sheet tabs, but within a small
range instead of a workbook.

Is this possible? Or have I smoked too much crack this time?


havocdragon

LanceB, Unfortuneatly a pivot table requires a pre existing source of
information in the form of a databse. What im looking for would be for manual
design and inputs.

"LanceB" wrote:

Looking through the smoke from the crack, it appears you might want to look
at pivot tables, but I'm not sure, crack being what iit is.

Lance

"havocdragon" wrote:

Hello all.

This is a shot in the dark, and I'll see if I can explain what I am talking
about =).
I wan't to add some tab functinality to a range of cells, so that lets say I
have 10 sources of info but I dont want it to take up 2 pages thats hard to
read, but it still needs to be in the middle of some information. So lets say
I have A10 through J20 that has infomation in it on one tab, then I would
like to click another tab, and have A10 through J20 to display some different
information. Basically the samething as the sheet tabs, but within a small
range instead of a workbook.

Is this possible? Or have I smoked too much crack this time?



All times are GMT +1. The time now is 12:18 AM.

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