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
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