Grabbing recods based on date and shift values

J

Jay

I have this XP excel application which list (A,B,C,D) workshift values by
date. What management wants to do is grab any and all values by complete
record in this application and plug them unto a new worksheet assigned to
accumulate this data by shift and by month in sequence chronoligically.
Current records look like this:
Column headers between these double lines
==============================
Shift Date Airwear Substrates Counter Start Stop Ack Waiting for
Lenses Machine Power On Off Time Off Time Goal 20 Min Stop Time Goal
1h10m Waiting for Lenses Goal 10 Mins Ack Ack Goal 1Hour 20 Mins Processing
Lenses Excluding Ack Time Processing Lenses Goal 9 Hours Lenses
Processed Lenses Goal 6000
=============================
D 11/29 Airwear 4166 10:15:39 1:48:31 3:06:25 0:12:15 12:04:29
B 12/1 Airwear 4606 9:06:48 2:25:35 1:44:53 0:06:57 11:32:47
A 12/2 Airwear 3956 2:50:31 2:30:31 4:01:44 0:49:42 5:21:36
D 12/2 Airwear 3456 8:26:21 2:40:12 1:41:41 0:27:55 11:06:33
==========
What I need to end up with is something like this on each page representing
a shift and month value in section of said worksheet assigned to particular
in groups of monthly value seperated by two blank lines/records:

A 6/29 Airwear 5196 9:10:07 2:40:26 1:25:48 0:08:54 12:00:00 0:00:00 0:20:00 2:40:26 1:10:00 0:08:54 0:10:00 1:25:48 1:20:00 7:35:25 9:00:00 5196 6000 05.26

A 7/2 Airwear 4054 10:29:51 1:30:20 1:30:53 1:21:38 12:00:28 0:00:00 0:20:00 1:30:20 1:10:00 1:21:38 0:10:00 1:30:53 1:20:00 7:37:20 9:00:00 4054 6000 06.77

A 8/3 Airwear 2418 4:58:45 6:40:08 1:06:38 0:27:04 11:39:17 0:20:43 0:20:00 6:40:08 1:10:00 0:27:04 0:10:00 1:06:38 1:20:00 3:25:03 9:00:00 2418 6000 05.09

==============
Is this possible! All I need, if it's possble is, a sample of the function
to grab the values per record and I'll do the rest of the values across the
record.

Thanks,
 
K

Ken Wright

Off the top of my head I'd say that if this App is spitting data out in a
database style format, then try throwing a pivot table at it and see if you
can build that report. As long as the data is date based you can group it
in a multitude of different ways. Debra Dalgleish has a gret intro to pivot
Tables at the following link, so perhaps take a couple of minutes to have a
look at that:-

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top