I need some help/ideas in creating a macro or subroutine that returns the
column heading of the last cell in a row series that is not blank, and
populates the column heading in a cell adjacent to the last task date.

I'm using a worksheet to track the dates of when a particular task is
completed, and then I want to know what was the last task completed in this
series in the cell next to the last task on that row. The data looks like
this:


Task 1 Task 2 Task 3 Task 4 Task 5 Last Task
completed
4/1 4/5 4/6 4/8
Task 4
3/8 3/7
Task 2
3/15 3/17 3/18 3/22 3/29
Task 5
4/12 4/14 4/15
Task 3

....and so on.

What I'd like to do is have Excel check the row to see if it has a date
value and then go to the next cell until it finds one that is blank. If it
is blank, then return the column heading (task) of the last cell that was not
blank in the appropriate cell (in this case "Last Task Completed".

I'm using Excel 2000 and I'm comfortable using Excel, but beyond writing
simple macros and functions - I'm somewhat limited as I'm not familiar with
writing VBA code.

So any ideas or suggestions will be greatly appreciated!
--
Thanks, Wil H.