Hi
use Ron's easyfilter addin for this
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"D@annyBoy" schrieb im Newsbeitrag
...
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