Hi,
Having dipped in and out of this forum for the past 506 days (I am reminded) I finally get round to my first post. I am an Informatics Nurse working on a rostering project. Due to our recession in Ireland my service does not have the resources to hire programming expertise so I have undertaken to do the work. I am using Excel 2003 to manage the rostering process and have made good progress to date, having a working system up and running. I am now trying to improve the process by automating certain elements. I need a macro to assist me manage changes of duty (i.e. where one staff member works for another on a shift). I am attaching a worksheet to help outline the task. The range A7:D28 contains a main list of all staff normally available for the shift, range E31:E45 contains the names of staff from this main list who have staff from an opposite shift in D31:D45, working for them. My objective is to search in the main list for matches of staff who have others working for them and replace the name in the relevant cell. e.g Staff 57 at D31 matches C22, - replace with staff at C31. Hope this explains what I need.
Many thanks in Advance.
Changes.xls
Bookmarks