Dynamic Fill Down

[just1joe]

I have a table with date in one column and time in another. The date value is only filled out once per day. I would like to fill the date down until it hits the next date and then use that date to fill down and so on as long as I have a value in the time column.

Date Time
04/03 12:00
13:00
13:30
14:00
14:30
04/04 12:00
13:00
13:30
14:00
04/05 12:00
13:00
13:30

- Joseph

 

[MikeL]

I got help from this board to a similar problem recently. Try this:

Highlight the range.
Choose Edit-GoTo(or press the F5 key).
Click on the Special button.
Choose Blanks, Then OK. ( This should highlight only the blanks in the range?

Then type =, the up arrow, the Ctrl key and Enter.

This should fill in all the empty cells.

Hope this works.
MikeL

 

[just1joe]

That did the trick,

Thanks.