New to VBA - Multiple sheets

[Wolf66]

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

[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.

---
Regards,
Norman



"Wolf66" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[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.