automate creation of sheets in excel
is there anyway to automate creation of sheets in excel? I would like to
have one sheet that has a master list of all items. then a have sheets which
are automaticaly generated, 1 sheet for every 30 items on the master sheet.
can this be done? is there some vba built into excell that i could use to do
this?
Anne Troy - 23 Jun 2005 19:26 GMT
You could try something like this, Daniel:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=318
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
> automate creation of sheets in excel
>
[quoted text clipped - 3 lines]
> can this be done? is there some vba built into excell that i could use to do
> this?