Hope someone can help with this, I have a workbook allocating men to machines. The details are in a range 3Cx9R for each rota and there are 9 variations of the rota in named ranges rota a, rota b, rota c, etc
What I need to be able to do is read a letter from a cell and replace the current rota with one corresponding to the new letter for example rota a this week, rota b next week.

Hope this makes sense, let me know if more information would be helpful

Thanks in anticipation of a solution

Martin