Creating multiple sheets - new to programming
 

Want to create multiple worksheets (variable # up to 100) formatted same as
first sheet where daily production values are entered each day. On sheets
following the first want totals derived as follows:

sheet1
A1=day production total (numeric)
A2=job production total (numeric0
A3=date in dd-mmm-yy format

want
sheet2(A2)=sheet1(A2)+sheet2(A1)
sheet3=sheet2(A2)+sheet3(A1)
sheet4=sheet3(A2)+shee4(A1)
..... up to total # of sheets in workbook, depends on project length.

sheet1(A3)=date
sheet2(A3)=date+1
sheet3(A3)=date+2

Can sheet2 & successive sheets be named with the value contained in (A3) ie
sheet2 name =date+1, sheet3 name=date+2?

Can anyone recommend any other sites for a newbie to VB or books for Excel
programming?

Tx Ivor

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200512/1