i have an application that tracks 18 workbooks (one for each person) right
now. each workbook has 12 sheets, 1 for each month and a line for each day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours by
(3)branch for each day. like i mentioned, there are 18 workbooks right now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still need to
check each person's workbook, even if they don't happen to work this day.
then i need to look at the branch code that's entered for this day, and add
the total hours for each of 5 branches and total transactions for each of 5
branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary

We believe a macro would be best

We can input the month and day of interest,

loop through each workbook
select sheets(month).rows(day)
check for working condition
If not working, do nothing
If working, copy this row to report workbook
end of loop

sort report workbook by branch
Subtotal by branch


"Gary Keramidas" wrote:

i have an application that tracks 18 workbooks (one for each person) right
now. each workbook has 12 sheets, 1 for each month and a line for each day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours by
(3)branch for each day. like i mentioned, there are 18 workbooks right now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still need to
check each person's workbook, even if they don't happen to work this day.
then i need to look at the branch code that's entered for this day, and add
the total hours for each of 5 branches and total transactions for each of 5
branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary

visual help:
here's what the input sheet looks like

Date Short Over Adj OoB Total Hours Count Err # of CO # of Tardy Ref
G / M Disciplinary
V W S B
01

this extends down for each day

i need to look at the code in the "B" column,
then add up the count and the hours for each of 5 possible codes in the "B"
column for al 18 workbooks for each day


--


Gary


"Gary Keramidas" wrote in message
...
i have an application that tracks 18 workbooks (one for each person) right
now. each workbook has 12 sheets, 1 for each month and a line for each day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours by
(3)branch for each day. like i mentioned, there are 18 workbooks right
now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still need
to check each person's workbook, even if they don't happen to work this
day.
then i need to look at the branch code that's entered for this day, and
add the total hours for each of 5 branches and total transactions for each
of 5 branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary

Send us a list of the 18 filenames
how you name the sheets (1, 2, 3 or Jan, Feb, Mar)
first few lines of a typical sheet with headings
we can give it a try

the way you listed the headings is unreadable.
Can you send a typical file?

"Gary Keramidas" wrote:

visual help:
here's what the input sheet looks like

Date Short Over Adj OoB Total Hours Count Err # of CO # of Tardy Ref
G / M Disciplinary
V W S B
01

this extends down for each day

i need to look at the code in the "B" column,
then add up the count and the hours for each of 5 possible codes in the "B"
column for al 18 workbooks for each day


--


Gary


"Gary Keramidas" wrote in message
...
i have an application that tracks 18 workbooks (one for each person) right
now. each workbook has 12 sheets, 1 for each month and a line for each day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours by
(3)branch for each day. like i mentioned, there are 18 workbooks right
now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still need
to check each person's workbook, even if they don't happen to work this
day.
then i need to look at the branch code that's entered for this day, and
add the total hours for each of 5 branches and total transactions for each
of 5 branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary

want me to email it to you?

--


Gary


"PY & Associates" wrote in message
...
Send us a list of the 18 filenames
how you name the sheets (1, 2, 3 or Jan, Feb, Mar)
first few lines of a typical sheet with headings
we can give it a try

the way you listed the headings is unreadable.
Can you send a typical file?

"Gary Keramidas" wrote:

visual help:
here's what the input sheet looks like

Date Short Over Adj OoB Total Hours Count Err # of CO # of Tardy
Ref
G / M Disciplinary
V W S B
01

this extends down for each day

i need to look at the code in the "B" column,
then add up the count and the hours for each of 5 possible codes in the
"B"
column for al 18 workbooks for each day


--


Gary


"Gary Keramidas" wrote in message
...
i have an application that tracks 18 workbooks (one for each person)
right
now. each workbook has 12 sheets, 1 for each month and a line for each
day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours
by
(3)branch for each day. like i mentioned, there are 18 workbooks right
now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still
need
to check each person's workbook, even if they don't happen to work this
day.
then i need to look at the branch code that's entered for this day, and
add the total hours for each of 5 branches and total transactions for
each
of 5 branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary

please

"Gary Keramidas" wrote:

want me to email it to you?

--


Gary


"PY & Associates" wrote in message
...
Send us a list of the 18 filenames
how you name the sheets (1, 2, 3 or Jan, Feb, Mar)
first few lines of a typical sheet with headings
we can give it a try

the way you listed the headings is unreadable.
Can you send a typical file?

"Gary Keramidas" wrote:

visual help:
here's what the input sheet looks like

Date Short Over Adj OoB Total Hours Count Err # of CO # of Tardy
Ref
G / M Disciplinary
V W S B
01

this extends down for each day

i need to look at the code in the "B" column,
then add up the count and the hours for each of 5 possible codes in the
"B"
column for al 18 workbooks for each day


--


Gary


"Gary Keramidas" wrote in message
...
i have an application that tracks 18 workbooks (one for each person)
right
now. each workbook has 12 sheets, 1 for each month and a line for each
day
of the month. i now summarize some of the data monthly, on each monthly
sheet and report it in a separate workbook

now, the client is asking for some daily summaries in another separate
workbook. specifically i need 3 items, (1) transactions and (2)hours
by
(3)branch for each day. like i mentioned, there are 18 workbooks right
now.

so i am looking for the best way to do this.

for example:

august 29th would have between 10 and 18 possibilities, but i still
need
to check each person's workbook, even if they don't happen to work this
day.
then i need to look at the branch code that's entered for this day, and
add the total hours for each of 5 branches and total transactions for
each
of 5 branches for this day.

then i need it for every day of the month and ultimately the year.

how would you handled this? long formulas?
--


Gary