M
Martin B
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
(e-mail address removed)
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
(e-mail address removed)