I have a database Query that generates information as follows:

Date, Day of the Week, Hour Day, Value1, Value2


The problem is that since it's a database query, if there's n
inforamtion for a particular hour of the day, it just skips over tha
hour.

Like so:

8/3/2004, 3, 2, 100, 700
8/3/2004, 3, 3, 150, 845
8/3/2004, 3, 4, 231, 101
8/3/2004, 3, 6, 171, 842

What I need is a macro to cycle through and fill in places where ther
is no data.. so the above would turn in to:

8/3/2004, 3, 2, 100, 700
8/3/2004, 3, 3, 150, 845
8/3/2004, 3, 4, 231, 101
8/3/2004, 3, 5, 0, 0
8/3/2004, 3, 6, 171, 842

This is also for multiple days, so at midnight it goes from
8/3/2004, 3, 23, 104, 543

to

8/4/2004, 3, 0, 78, 163

Any pointers on how to get started

--
Message posted from http://www.ExcelForum.com