Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying formulas with code
I have a workbook where values in row C contain worksheet names. VBA code
creates additional worksheets naming the worksheet with what is entered in column C. There is also a summary worksheet which Sums like cells from all the worksheets. Looking for assistance in creating code which would modify the SUM formula on the summary worksheet each time new worksheets are added. -Rick |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying formulas with code
Any ideas for a variation on this -
I have sheets set like this- <MonthType1<MonthType2<MonthType3<PreviousMonth Type1<PreviousMonthType2<PreviousMonthType3 etc.... I want to maintain the order of the grouping, but summarize each typ (SummaryType1, SummaryType2, SummaryType3) with formulae that wil automatically update when I add new sheets each month. Is i possible? Seems like the First:Last trick won't quite work given the groupin order of the sheets... Thanks for any help -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying formulas with code
It will if you put them around each group.
-- Regards, Tom Ogilvy Andy Z wrote in message ... Any ideas for a variation on this - I have sheets set like this- <MonthType1<MonthType2<MonthType3<PreviousMonth Type1<PreviousMonthType2 <PreviousMonthType3 etc.... I want to maintain the order of the grouping, but summarize each type (SummaryType1, SummaryType2, SummaryType3) with formulae that will automatically update when I add new sheets each month. Is it possible? Seems like the First:Last trick won't quite work given the grouping order of the sheets... Thanks for any help! --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
modifying formulas with code
I considered that, but the problem is - group1 contains worksheets o
type1, type2, and type3. Group2 contains the three types as well. want the summary pages to summarize by type, not by group. But, stil maintain the grouping structure of the worksheets. I think I must b missing something? I am pretty much resigned to the fact I'll just have to copy ol worksheets and update the formulas manually. No big deal, I was jus hoping for something slicker. Tom Ogilvy wrote: *Xref: TK2MSFTNGP08.phx.gb microsoft.public.excel.programming:461474 It will if you put them around each group. -- Regards, Tom Ogilvy Andy Z wrote in message ... Any ideas for a variation on this - I have sheets set like this- <MonthType1<MonthType2<MonthType3<PreviousMonth Type1<PreviousMonthType2 <PreviousMonthType3 etc.... I want to maintain the order of the grouping, but summarize eac type (SummaryType1, SummaryType2, SummaryType3) with formulae that will automatically update when I add new sheets each month. Is it possible? Seems like the First:Last trick won't quite work given th grouping order of the sheets... Thanks for any help! --- Message posted from http://www.ExcelForum.com/ -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modifying sumif formulas. | Excel Worksheet Functions | |||
Modifying formulas through code | Excel Programming | |||
Need Help Modifying Code | Excel Programming | |||
Help modifying code | Excel Programming | |||
Modifying Code that deletes a Row | Excel Programming |