Any excel experts able to help

[cocker92]

hi guys im trying to do two things...

1. i want to be able to enter a date in one box ie A1 and the next three days to be auto inputted into 3 other boxes ie A6,C1 AND C6. is there a way?

2.also iv used data validation to creat a drop down list of names. is there a way that once a name has been used from the drop down box in column b1, the next the drop down is selected in b2 the previously selected name isnt available but the remaining names are fopr selection.

cheers for any help given

 

[MarcLister]

For the date, enter the date you want into A1 then in A6, C1 and C6 have a formula for each that says '=A1+1' for the day after, or +2 for two days after.

 

[cocker92]

yeeeees so easy lol.

cheers

any suggestions with the second one lol????

cheers
simon

 

[MarcLister]

yeeeees so easy lol.

cheers

Yup. Hence why I answered.

any suggestions with the second one lol????

cheers
simon

Not sure I understand? Are you saying you want a name you've just selected to be removed from the list for next time round? Perhaps if you re-explain what you want I can help.