|
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 |
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 |
| All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com