ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   governing sheets (https://www.excelbanter.com/excel-discussion-misc-queries/124758-governing-sheets.html)

Joe

governing sheets
 
I would like to know if anyone knows how to do this. I want to program a
sheet in my workbook which will other sheets in the workbook. A control page
if you will. My control page will then govern how many columns and rows go
into other pages in the workbook. Does that make sense?



paul

governing sheets
 
Not 100 per cent clear what you want
You can make a blank copy of your governing sheet and move/copy it as
required when you want a new sheet.
You can write formulas and or macro's to fill in rows and columns as
required depending on new/existing data or data ranges,but tyou will have to
be a little more forthcoming with what you have/need
--
paul

remove nospam for email addy!



"Joe" wrote:

I would like to know if anyone knows how to do this. I want to program a
sheet in my workbook which will other sheets in the workbook. A control page
if you will. My control page will then govern how many columns and rows go
into other pages in the workbook. Does that make sense?




All times are GMT +1. The time now is 09:11 AM.

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