Hi!

This can be done if you set it up properly. It would also
require a lot of formulas (depending on how many vehicles
you have)- 12 * number of vehicles.

To make things as easy as possible the dates in your
columnar data and the 12 months in the calander must be
true Excel dates.

For the 12 calander months you can enter any date of a
particular month and just format the cells as MMM. For
example, you can enter 1/1 for January and then format as
MMM to give you the displayed value of Jan.

For the purposes of this example I will use this sample
data as your list and it's located in the range O1:Q10

1 1-Jan brake
2 5-Nov tune
3 6-Oct insp
4 1-Feb insp
5 1-Mar tune
6 1-Apr brake
7 1-May align
8 1-Aug muff
9 1-Sep tires
10 1-Jun oil

Now, assume that in your "calander" the vehicle ID's start
in A2. The months are listed in B1:M1.

In B2 enter this array formula using the key combo of
CTRL,SHIFT,ENTER:

=INDEX($Q$1:$Q$10,MATCH(1,($O$1:$O$10=$A2)*(MONTH
($P$1:$P$10)=MONTH(B$1)),0))

Copy across then down to fill the calander. You will get a
lot of #N/A errors where there is no matching data. You
can either suppress the #N/A's from being displayed by use
of the formula or you can hide the #N/A's using
conditional formatting. Personally, I would use cf.

Biff

-----Original Message-----
I'm trying to create a calendar speadsheet from a list of
information. Let's
say my data is in the form of three COL. The first is a
vehicle ID, second
is a due date, and lastly number three is what work is
due for that vehicle
on that date. I'm trying to bring it over into a
spreedsheet with the
vehicles listed in down in col 1 then the months spread
accorross the top
from Jan in col 2 through Dec in col 13. Any help you
can give me is greatly
appreciated.
.