W
Wolf66
Hi, Any help appreciated!
Want to create multiple worksheets at the same time, up to 100, base
on first sheet of workbook, format the same, some values changin
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 valu
eg date format of the first worksheet?
New to programming Excel, found David McRitchie's site to help
Tx in advanc
Want to create multiple worksheets at the same time, up to 100, base
on first sheet of workbook, format the same, some values changin
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 valu
eg date format of the first worksheet?
New to programming Excel, found David McRitchie's site to help
Tx in advanc