![]() |
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? |
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? |
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