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