View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin B Martin B is offline
external usenet poster
 
Posts: 16
Default Named ranged selection problem

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