ExcelBanter - creating sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - creating sheets (https://www.excelbanter.com/excel-discussion-misc-queries/233927-creating-sheets.html)

I have a list of 250 +/- people, that I would like to be able to update on a
weekly basis. This list would then drive the 250 sheets in the excel file.
As I add new names, the various sheets would then update, along with as I
delete names the sheets would be removed.
Is there some way that I can run this without having to go threw and create
new sheets as my list grows, and I do not print out additional sheets as my
list shrinks.

Any help would be greatly appricated.

Hi CSWP

Not sure if I understand you correct but maybe this is a start
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"CSWP" wrote in message ...
I have a list of 250 +/- people, that I would like to be able to update on a
weekly basis. This list would then drive the 250 sheets in the excel file.
As I add new names, the various sheets would then update, along with as I
delete names the sheets would be removed.
Is there some way that I can run this without having to go threw and create
new sheets as my list grows, and I do not print out additional sheets as my
list shrinks.

Any help would be greatly appricated.