New to VBA - Multiple sheets
 

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

--
Wolf6
-----------------------------------------------------------------------
Wolf66's Profile: http://www.excelforum.com/member.php...fo&userid=2487
View this thread: http://www.excelforum.com/showthread.php?threadid=48842

New to VBA - Multiple sheets
 

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

New to VBA - Multiple sheets
 

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


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