About Us

PY & Associates[_4_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conceptual Question about ReDim	Tom Ogilvy	Excel Programming	0	April 14th 05 03:51 PM
Conceptual Question about ReDim	Chip Pearson	Excel Programming	0	April 14th 05 03:50 PM
need some conceptual guidance, advanced excel	marika1981	Excel Programming	1	February 16th 05 03:04 AM
new guy with a conceptual question	Jay[_16_]	Excel Programming	3	March 5th 04 06:59 PM
Conceptual Problem with DAO/ADO Recordset	Eddy[_3_]	Excel Programming	0	September 8th 03 07:43 AM

Menu

About Us