Data extraction

[Shrek1972]

Dear All

I'm new to VBA and can't seem to crack how it all comes together. I have a database of raw data from which I need to extrapolate different dates & times from several columns and average the values into a new column in a KPI report. This I need to do for about 300,000 records since the data contains dates & times for different business units. Is there anyone that can help me with a code for this sort of thing? Below is an example of what it should look like as the end result

REGIONAL LOGISTICS KPI REPORT
		Northern Region		Regional Score		88%
		19-Dec-13
BUSINESS UNIT PERFORMANCE
		Business Unit		North West		Limpopo East		Limpopo West		Mpumalanga		Rekopane		DGM		TAD
		Overall Score					90%		83%		88%		76%		85%		95%		97%
		Super Group Score					93%		90%		96%		78%		88%		102%		99%
		TAT "In Lab" (Hrs)					49		56		49		57		69		55		100
		TAT "Referrals" (Hrs)				112		126		112		138		96		0		0
		Number of Routes					27		25		26		32		23		3		9
		Last SLA meeting					15-Oct-13		15-Oct-13		15-Oct-13		15-Oct-13		15-Oct-13		15-Oct-13		15-Oct-13
			Referral		In Lab
			Target (Hrs)		Target (Hrs)		Average		Average		Average		Average		Average		Average		Average
TAT REPORT	29		23		80%		67%		76%		52%		70%		91%		94%
Collection Performance
	(From sample readyness)	12		12		7.46		14.29		12.28		11.93		9.63		8.26		6.65
	(From Collection to Delivery)	3		3		1.84		1.78		1.96		2.65		2.02		1.38		1.97
Pre-analytical Performance
	(From Delivery to capture)	3.51		3.51		3.38		10.75		6.70		6.26		4.30		7.09		5.39
	(From capture to Referal)	1		1		7.38		5.09		2.27		7.02		3.60		1		1
Referral Performance
	(From Referral to receiving)	12		5		11.91		11.99		6.65		16.39		10.92		12		12
Delivery Performance
	(From Report Print to Report Collect)	12		5		30.57		44.46		40.36		36.79		33.24		26.91		66.13
	(Delivery of Reports)	3		3		3.12		2.26		2.15		5.54		4.10		1.90		1.81
SERVICE PROVIDER PERFORMANCE				100%		100%		100%		100%		100%		100%		100%
	Number of Vehicles					20		25		25		21		23		2		5
	Vehicle Compliance			100%		100%		100%		100%		100%		100%		100%		100%
	Driver compliance			100%		100%		100%		100%		100%		100%		100%		95%
	Trip Sheet Compliance			100%		100%		100%		100%		95%		100%		100%		100%
	Scanning Compliance			100%		100%		100%		100%		100%		100%		100%		100%
	Tracking Compliance			100%		100%		100%		100%		100%		100%		100%		100%

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[bstory84]

Not enough detail to really help. I would like to suggest that if you are already able to get the information from the database, if possible use an SQL statement to accomplish this.
If not then are you able to import to excel using the actual table data? rather than the report that you posted.

 

[Shrek1972]

@bstory84, thanks for your response. Can I perhaps mail you a copy of the raw data file?

 

[bstory84]

I sent you a PM.