+ Reply to Thread
Results 1 to 3 of 3

UDF to return one of each word found in a column to a single cell on another sheet

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    2011 for MAC
    Posts
    2

    UDF to return one of each word found in a column to a single cell on another sheet

    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.
    Attached Files Attached Files
    Last edited by Doing my best; 07-15-2014 at 12:11 PM. Reason: Didn't include attachment

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: UDF to return one of each word found in a column to a single cell on another sheet

    Welcome to the forum.

    I don't see any attachment.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    Wisconsin, USA
    MS-Off Ver
    2011 for MAC
    Posts
    2

    Re: UDF to return one of each word found in a column to a single cell on another sheet

    Sorry. Wasn't sure that I needed to. I've fixed it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] looking to find 1 of 2 words in a cell in column B and return the word found in the same
    By Rob69mfj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-27-2014, 01:17 PM
  2. [SOLVED] Copy row from one sheet and paste to another if a key word is found in 1 column of sheet 1
    By killdozer in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-17-2014, 02:27 PM
  3. Replies: 4
    Last Post: 05-07-2012, 10:53 PM
  4. [SOLVED] Find and return a word, in a list of words, that is in a single cell.
    By nicholas.jacka in forum Excel General
    Replies: 2
    Last Post: 03-07-2012, 05:13 AM
  5. Using "Find" to return results if a word is found within multiple words in a cell
    By pylauzier in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2011, 01:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1