Create a Drop down list with dates based on adjacent Cell

[smugglersblues]

Hi,
I'm looking for a macro that will take the date in H1 and create a drop list that adds two days before and two days after the the date in H1. The drop list will be in F1 and G1. And finally the macro should find the last empty row and stop. So if there are dates in H1:H50, it will add a drop list in F1:G50. Is this possible?

[rcm]

try the macro

[smugglersblues]

Hi rcm,
I forgot to mention I'm stuck on Excel 03 right now. In your spread sheet you have extra columns to the right of H with dates already entered. Is it possible to not have a lookup table for this? Can the macro take the date in H1 and do the math to figure out which dates to put in the drop list?

[smugglersblues]

Your macro works as it is. But the lookup table doesn't fit in this project I'm working on.

[rcm]

I'll work on it

[AlphaFrog]

Another method. If the cells in F and G are merged, you only need to add the lists to the cells in column F

Please Login or Register  to view this content.

[smugglersblues]

Thank you, it's perferct. And thanks rcm for your input too. It's greatly appreciated.

[rcm]

You are welcome. and thanks Alphafrog for the enlightment