Hi Shooter

can't advise what is the best method as i don't work with workbooks or
worksheets of the size you are talking about, but if you decide to create a
200 sheet workbook then this (IMHO) is probably the easiest way to do it.

Choose tools / options / general - change "sheets in a new workbook" to 200
click OK
open a new workbook - it will now have 200 sheets
Choose tools / options / general - change "sheets in a new workbook" back to
3 click OK
set up the first sheet like you want all of the others
right mouse click on the sheet tab and choose "all sheets"
select the whole of the first sheet (ctrl & A - twice if it doesn't select
everything the first time)
choose edit / fill across worksheets - ALL
click on cell A1
right mouse click on the sheet tab and choose Ungroup Sheets

your sheets should all now be set up for you.

Cheers
julieD


"Shooter" wrote in message
...
I would like to create approx. 200 worksheets in one workbook. Is there a
limit to the number of worksheets that a workbook will hold? Is there a
quick
method to copy my master spreadsheet to 200 other worksheets?

My master spreadheet is an annual budget for a commercial property. I am
setting up budgets for 200 properties. When dealing with this many
properties/worksheets is it more advisable to set up the budget template
to
repeat itself in one worksheet which may require approx. 15,000 rows or is
the method noted above (create 200 worksheets with approx 75
rows/worksheet)
the better method? This is a big job so I thought I would try to get some
advise before I start. Thanks for your suggestions.
--
Shooter