New to VBA - Multiple sheets

[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

 

[Norman Jones]

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.

 

[Wolf66]

Tx for the reply Norman, here are some more details:

Sheet 1 day 1 of project
A1 = day production total (numeric)
A2 = cumulative day production totals
A3 = date in d-mmm-yy format

Want to create variable number of sheets formatted same as sheet 1
where daily production values are entered each day. Would like A1-A3 on
successive sheets to contain the following values:

sheet2(A2) = sheet1(A2)+sheet2(A1)
sheet3(A2)=sheet2(A2)+sheet3(A1)
sheet4(A2)=sheet3(A2)+sheet4(A1)

sheet1(A3)=start date
sheet2(A3)=start date + 1
Can sheet2 be named with date value in sheet2(A3)?
sheet3(A3)=start date+2 , sheet named with date value in sheet3(A3)

Make sense?

Tx.


sheet3(A3)=start date +2