how to automatically fill a list after making a selection from a drop down list

[Wai-Chung]

Hello,

I was wondering if it is possible to first make a selection from a drop down list and then have the following columns automatically filled with another list based on the first selection?
For example, if I chose Nov 30 from a drop down list, can I then have the columns below it filled with the list Nov 15, Oct 31, Oct 15... automatically? However, this list would change if my starting date was say Aug 31; then it would be Aug 31, Aug 15, Jul 31, Jul 15.

I have tried doing vlookup, but I am still not familiar with the concept so I am hoping that someone in this forum can give me some advice.

Thank you very much for your help.

Chung

 

[Hui]

Chung

Firstly, Welcome to the Chandoo.org Forums

If your drop down in in A1
then simply use formulas such as
B3: =EOMONTH(A1,-1)+15
B4: =EOMONTH(B3,-1)
B5: =EOMONTH(B4,-1)+15
B6: =EOMONTH(B5,-1)
B7: =EOMONTH(B6,-1)+15
etc

see attached file:

 

[Wai-Chung]

Thank you very much Hui for your help. It will save me a lot of time from typing the different dates.

Chung