| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
Threaded Mode
