I have been trying to put all my data in one work sheet and then extract the
data to another worksheet but I think it is going to be pretty hard for me


"Frank Kabel" wrote in message
...
Hi
number of sheets depends mostly on your memory.
Normally it is better to use a database data layout on one SINGLE
sheet. That is use the property name as one column and add the other
data in the respective columns. This way you can use Excel's filter,,
sort, pivot table functions

--
Regards
Frank Kabel
Frankfurt, Germany

"Shooter" schrieb im Newsbeitrag
...
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