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