Hi Wolf,

I think that you would need to explain the rule which governs the values to
be assigned to the added sheets.

In the absence of a discernable rule

etc

has no meaning.

---
Regards,
Norman



"Wolf66" wrote in
message ...

Hi, Any help appreciated!

Want to create multiple worksheets at the same time, up to 100, based
on first sheet of workbook, format the same, some values changing
within the subsequent sheets accumulating the previous days values

Sheet1 A1=10 B1=5 C1=10 D1=5
Sheet2 A1=12 B1=7 C1=Sheet1(C1)+12 D1=Sheet1(D1)+7
Sheet3 A1=9 B1=0 C1=Sheet2(C1)+9 D1=Sheet2(D1)+0
etc
Also can the subsequent worksheet tabs be named based on a cell value
eg date format of the first worksheet?

New to programming Excel, found David McRitchie's site to help

Tx in advance


--
Wolf66
------------------------------------------------------------------------
Wolf66's Profile:
http://www.excelforum.com/member.php...o&userid=24875
View this thread: http://www.excelforum.com/showthread...hreadid=488428