My project is a daily nursing schedule. Next to each name is a drop down list to annotate if the staff called in sick or worked overtime, etc. That column contains the following initials (SL, CB, EAL, AWOL, LWOP) as well as the numbers 1-8 to identify number of overtime hours worked, if applicable. On another sheet is the summary for the day which compares the total number of staff originally scheduled with the number that actually worked on each unit for each of three shifts. One cell for each type of staff on each shift will contain the codes from the first sheet (i.e. SL, CB, etc) that explain the variation between scheduled and actual staff. Most of the time this cell will contain only SL but it occasionally contain 2 or more.
OK, that is the scenario. What I need is a UDF (I'm a VBA beginner) that searches the column on one sheet and returns only 1 of each abbreviation found to the single cell on the second sheet. I'd prefer the the results to be separated by a comma, space or both.
Attached is a portion of the workbook with all names removed. H51:H59 on sheet 1 represent the area I need to search. Cell K17 is the location on sheet 2 where I need to insert the abbreviations found.
Thanks a lot.
Bookmarks