Hi all

I have a requirement to provide a stat analysis based upon the movement of
my vehicle fleet. Each vehicle visits a number of locations everyday. The
arrival and departure times are recorded in my parcel tracking system which
is held on my SQL 2000 database.

What I need to do is to show a headline page of average delivery times over
a period of 13 weeks and then a seperate worksheet showing the specific
detail for each delivery point.

So far I have started my project in the following way.

1. I have a worksheet that queries my database for a current list of
delivery points
2. I have a worksheet that queries my delivery data to show each daily
delivery time in and out
3. I have a VBA code snippet that creates worksheets based upon the list of
delivery points and orders them alphabetically

I have my sql query ready to extract the data from my database but I have no
idea how to place only relevant data into each worksheet. Each worksheet is
named as its delivery point so i need to know howto get each worksheet to
hold only the data related .

Or.... Am I approaching this completely wrong?

Any ideas appreciated

Gavin

Consider using Pivot Tables: you might be able to deliverthe solution without
any programming at all.

"Gavin Jones" wrote:

Hi all

I have a requirement to provide a stat analysis based upon the movement of
my vehicle fleet. Each vehicle visits a number of locations everyday. The
arrival and departure times are recorded in my parcel tracking system which
is held on my SQL 2000 database.

What I need to do is to show a headline page of average delivery times over
a period of 13 weeks and then a seperate worksheet showing the specific
detail for each delivery point.

So far I have started my project in the following way.

1. I have a worksheet that queries my database for a current list of
delivery points
2. I have a worksheet that queries my delivery data to show each daily
delivery time in and out
3. I have a VBA code snippet that creates worksheets based upon the list of
delivery points and orders them alphabetically

I have my sql query ready to extract the data from my database but I have no
idea how to place only relevant data into each worksheet. Each worksheet is
named as its delivery point so i need to know howto get each worksheet to
hold only the data related .

Or.... Am I approaching this completely wrong?

Any ideas appreciated

Gavin