#1   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 476
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 247
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
delete sheets from a workbook without creating linked formulae BlueTig Excel Discussion (Misc queries) 3 August 23rd 06 08:39 AM
selecting a single sheet from a volume of sheets in a workbook No News Excel Worksheet Functions 12 July 1st 06 05:29 AM
question about many sheets in one warkbook tzveti Excel Worksheet Functions 1 May 30th 06 05:42 PM
Microsoft Visual Basic: Compile error: Sum or Function not defined Dmitry Excel Worksheet Functions 12 April 3rd 06 07:28 AM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM


All times are GMT +1. The time now is 02:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"