LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Shooter
 
Posts: n/a
Default maximum number of worksheets

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
 
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
Number of worksheets Mark Excel Discussion (Misc queries) 1 January 18th 05 10:05 AM
Count the number of worksheets in a workbook Vincdc Excel Discussion (Misc queries) 7 January 17th 05 11:57 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 08:13 PM
Charting information from a number of worksheets Ian P Charts and Charting in Excel 1 January 14th 05 03:53 PM
Increase Number of Worksheets Hoochi Coochi Man Excel Discussion (Misc queries) 4 December 10th 04 04:17 PM


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

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

About Us

"It's about Microsoft Excel"