Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number of worksheets | Excel Discussion (Misc queries) | |||
Count the number of worksheets in a workbook | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Charting information from a number of worksheets | Charts and Charting in Excel | |||
Increase Number of Worksheets | Excel Discussion (Misc queries) |