I want to select from a drop down list and automatically add the other list items in order

[cyclingscott]

Hi,

I am trying to find a formula that will allow me to choose a day of the week from a drop down list and then automatically populate the following days of the week, in order, in other cells.

For example, if I choose Tuesday in cell D106, I would like Wednesday to appear in cell 110, Thursday in cell 114, Friday in cell 118 and so on. If possible I would also like to make it dependant on the number of days that I have entered in another cell. To add to the example, if I enter 7 days in cell B106 and choose Tuesday in cell D106 then every 4th cell in column D should have the next day of the week until we arrive at Monday. If I enter 8 days it would stop at Tuesday, if I enter 9 days, Wednesday, and so on.

Is that possible without using a Macro?

Many thanks in advance,
Scott

[cyclingscott]

In case it isn't clear from my description, here is a screen shot and a small Excel sheet:

Attachment 705996

[Glenn Kennedy]

One way:

=IF(1+INT((ROWS($1:5)-1)/4)>$B$2,"",INDEX($O$1:$O$7,1+MOD(VLOOKUP($D$2,$O$1:$P$7,2,FALSE)+INT((ROWS($1:1)-1)/4),7)))

with a slight alteration to your Data validation table in column P.

[cyclingscott]

That's great, thanks Glen!

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.