Can anyone help with this? One of my students is creating a spreadsheet based on a restaurant. On one work sheet he has various choices for starters etc in a drop-down list ( created from the list in validation), and the spreadsheet is going to calcuate the cost of the meal. He then wants to reset the worksheet for the next customer. What is the best way to do this? We have tried resetting all the choices manually and recording it as a macro, but for some reason it didn't work. Any ideas?