Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Multiple summary sheets | Excel Discussion (Misc queries) | |||
creating multiple sheets, then individualized workbooks for each sheet | Excel Discussion (Misc queries) | |||
creating macro working across multiple sheets | Excel Worksheet Functions | |||
Creating/programming an Excel dynamic graph | Excel Programming | |||
Creating an "update" button and using a macro to copy data from multiple sheets | Excel Programming |