Filling in dates

[anita.r]

I have a form where dates are entered, start dates and end dates, in column A and B. Four scenarios can be entered at once. What I need is for the entire date range to be displayed in column C.
Example: if I enter 1 January 2008 as a start date in A2 and 5 January 2008 as end date in B2, then I need 1 January 2008, 2 January 2008, 3 January 2008, 4 January 2008 and 5 January 2008 to be automatically entered into C2:C6. If I then enter 10 January 2008 as a start date in A3 and 12 January 2008 as end date in B3, then 10 January 2008, 11 January 2008 and 12 January 2008 is automatically entered into the next empty cell in column C, in this case C7:C9, etc. If I change or delete any of the start and end dates then the date range in column C must be automatically updated. It doesn't have to be in any order, as long as the date are reflected somewhere in column C, and deleted if the start/end dates are removed. I hope someone can help me with this issue.

Thanks in advance for any help this community can provide.

[dominicb]

Good afternoon anita.r

...and welcome to the forum!!

Does this macro solve your problem :

Please Login or Register  to view this content.

HTH

DominicB

[anita.r]

Thanks for the fast reply, the macro doesn't seem to be doing exactly what I need, it isn't filling in column C and then doesn't remove dates after updating the start and end dates.

[Charlize]

Please Login or Register  to view this content.

[dominicb]

Hi anita.r

...it isn't filling in column C...and then doesn't remove dates after updating the start and end dates...

Whoops! Iset it to go horizontally, instead of down. Try this modification :

Please Login or Register  to view this content.

HTH

DominicB

[Charlize]

Please Login or Register  to view this content.

[anita.r]

Thanks DominicB. That works great! Just one little modification I need, the macro deletes all data in column C when there are no start or end dates, is it possible to delete only the relevant dates?

[dominicb]

Hi anita.r

What do you mean by "relevant dates"?

DominicB

[anita.r]

There may be other data in column C that must not be deleted.

[dominicb]

Hi anita.r

This modified code will do the trick as long as there is a gap of at least one cell between the bottom of the dates and the information that should not be deleted. Is this going to be the case?

Please Login or Register  to view this content.

HTH

DominicB

[anita.r]

That will work for me, thanks very much.