Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary...Number of shts varies
The number of sheets in my workbook varies from day to day, with unique names for each sheet. I am trying to total cell contents from those sheets on a summary sheet. There is a cell whose contents are common to the sheet name. I am at a complete loss as to where to begin. There is not a lot of information here but I am not sure how to post enough to help. Remove nospam to respond via emai
Thanks in advanc Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary...Number of shts varies
if you are summing information across sheets and the information is in the
same cell on each sheet, put in a sheet named Start and a sheet named End. Put all sheets to be summarized between these two sheets. In the summary sheet use a 3D formula =Sum(Start:End!A1) as an example. All sheets between Start and End will be included in the sum (start and end should be blank sheets.) -- regards, tom Ogilvy "steveh" wrote in message ... The number of sheets in my workbook varies from day to day, with unique names for each sheet. I am trying to total cell contents from those sheets on a summary sheet. There is a cell whose contents are common to the sheet name. I am at a complete loss as to where to begin. There is not a lot of information here but I am not sure how to post enough to help. Remove nospam to respond via email Thanks in advance Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary...Number of shts varies
Or you can do it in VBA and use a for each loop
for each ws in activeworkbook.worksheets total = total + ws.cells(row,col).value next or something like that. -----Original Message----- if you are summing information across sheets and the information is in the same cell on each sheet, put in a sheet named Start and a sheet named End. Put all sheets to be summarized between these two sheets. In the summary sheet use a 3D formula =Sum(Start:End!A1) as an example. All sheets between Start and End will be included in the sum (start and end should be blank sheets.) -- regards, tom Ogilvy "steveh" wrote in message news:9FBA55CD-D981-4DAD-B107- ... The number of sheets in my workbook varies from day to day, with unique names for each sheet. I am trying to total cell contents from those sheets on a summary sheet. There is a cell whose contents are common to the sheet name. I am at a complete loss as to where to begin. There is not a lot of information here but I am not sure how to post enough to help. Remove nospam to respond via email Thanks in advance Steve . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of a range that varies | Excel Discussion (Misc queries) | |||
VLOOKUP using the act shts tab name as a reference for the table_a | Excel Discussion (Misc queries) | |||
formula to add cells in multiple shts in the same wkbk | Excel Worksheet Functions | |||
How to Compare Rows on 2 shts .... | Excel Discussion (Misc queries) | |||
Copying shts from one wbk to another | Excel Programming |