Karen
You say that you want Column A of the "Summary" to list the dates. Do
you mean you want me write the code (macros) to list all the dates or will
you list them? What will those dates look like? From what date to what
date? Otto
"Karen N." wrote in message
...
All of the time tracking sheets are named as "number,dash,number" - e.g.,
138-8 or 1067-13; whereas the inconsequential sheets are named with either
all text or "text number" - e.g., WAPG 2008. Does this qualify? If not,
I
can move the inconsequential sheets to a new workbook so this one only
contains the time trackers and summary.
--
~Karen N.


"Otto Moehrbach" wrote:

Karen
In writing the code, I have to include some way for Excel to
differentiate between what sheets to work with and what sheets to ignore.
The "Summary" sheet is easy. I presume it is named "Summary"
You said you have 6 "inconsequential" sheets and then you have 23 project
time tracking sheets. Think of that as being 2 groups of sheets. I need
to
be able to distinguish any given sheet as belonging to one group or the
other. If I can identify all the sheets of one group, I will not need to
identify sheets of the other group. They will simply be "the rest of the
sheets".
Can you think of any characteristic that is common to all the sheets of
one
group that is not present in any of the sheets of the other group?
Things
like:
The first character of the sheet name is a number.
The entry in cell XX is "Doodle".
The length of the sheet name is always X or always more/less than X.
I can always simply use the sheet names but it would simplify the code if
you know of any way to differentiate the 2 groups of sheets. Otto
"Karen N." wrote in message
...
Good morning Otto,

Yes, it was a lot - I wanted to make sure I covered all pertinent
information, but I tend to over-explain :)

Yes, I want all of the summations added together for each TheDate. I
don't
have anything against macros, except I have absolutely no idea how to
use
them! Is a macro be the solution to my issue?

Thanks and have a great day!
--
~Karen N.


"Otto Moehrbach" wrote:

Karen
That's a mouthful. You say the time tracking sheets have dates in
Column A with a blank row between months. See if I understand you.
Excel
will look at a date in Column A of the Summary sheet. Let's call that
TheDate for now. Excel will then look at each time tracking sheet and
search Column A for TheDate. If it finds TheDate, you want Excel to
sum
ALL
of Column Q in that sheet. Then you want Excel to look for TheDate
(the
same TheDate) in the rest of the time tracking sheets and, if found,
you
want those Column Qs summed as well? Do you want all those summations
added
together? And what have you got against macros? <g Otto
"Karen N." wrote in message
...
Hi,

I'm trying to build a summary sheet in a workbook that contains 30
worksheets - 6 sheets are inconsequential, 23 are time tracking
sheets
for
individual projects, and 1 is the summary sheet. I want the summary
sheet
to
list every day in Column A (e.g., 11/1, 11/2, etc.), and Column B to
house
the formula. I'm trying to get the formula to find the date in
Summary
Column A by looking in Column A of each of the 23 sheets, and if it
matches,
I want it to sum the total in Column Q.

The project time tracking sheets each have project info in the first
8
rows,
the column labels are in row 9 and then throughout the remainder of
the
sheet. Time tracking is separated by a blank row followed by a new
set
of
column labels to start the next month. Column A = Date, Column B =
project
status, Columns C-P = start/stop times, Column Q = time sum for each
row

In other words, I'd like a formula (no macros, add-ins, etc.) that
can
perform the following:
=SUMIF('ID 138-8:ID 1089-0'!A:A,Summary!A2,'ID 138-8:ID 1089-0'!Q:Q)
ID 138-8 = first time tracking sheet
ID 1089-0 = last time tracking sheet
Summary = summary sheet

I've spent hours trying to use consolidate, vlookup, if, dsum, etc.
formulas
to no avail, and I'm just not technically savvy enough to build a
multi-functional, nested formula. Any assistance in building a
'simple'
formula is greatly appreciated!

--
~Karen N.