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

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

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

It is limited by memory, look in help for specifications
Having said that I wouldn't want to do a beast like this. I would use
multiple workbooks

Regards,

Peo Sjoblom

"Shooter" wrote:

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

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

Hi DannyBoy

i saw your other post and i think you should have a look at pivot tables -
check out
http://peltiertech.com/Excel/Pivots/pivottables.htm
and
www.contextures.com/tiptech.html

for details on using these.

Cheers
JulieD

"D@annyBoy" wrote in message
...
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

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

thanks
looks interesting and will try it out


"Frank Kabel" wrote in message
...
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

The new outbreak of an Extraordinary Help designed by experts in MS Excel.
write to :


"Shooter" wrote:

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