Results 1 to 9 of 9

Macro to check the cell value and display the strings in another column

Threaded View

  1. 03-24-2016, 03:10 AM #1
    Mitiraj
    Mitiraj is offline
    Registered User
    Join Date
    03-21-2016
    Location
    SG
    MS-Off Ver
    2010
    Posts
    23

    Macro to check the cell value and display the strings in another column

    Hi All,

    I having an excel with different roles in column D. I need a macro to check the value in column D and display the description in column G.
    Example: Col D may have duplicate values for different persons. But, it has to take a unique value in column D and put their description in column G

    Sample excel is attached.
    Any help is appreciated. Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Delete only Alpha Strings but not Alphanumeric or Numeric Strings in a Cell
    By papageorgio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2016, 06:55 AM
  2. Compare two strings in different coloum and Check both strings are not exactly same..
    By prat123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2015, 11:45 AM
  3. [SOLVED] How to check if any one of the large group of strings are present in cell.
    By cool_anu4u in forum Excel General
    Replies: 9
    Last Post: 10-01-2013, 04:37 AM
  4. Macro to check column A and copy text from cell above
    By robertguy in forum Excel General
    Replies: 0
    Last Post: 08-20-2012, 09:22 AM
  5. Check listbox for specific strings only and if true run macro.
    By EthanM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2011, 07:03 AM
  6. most efficient way to check cell data against 3 known strings
    By scudder12 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-10-2010, 06:01 AM
  7. Search for an array of strings in a single cell and display adjacent cell value
    By tbabu in forum Excel General
    Replies: 2
    Last Post: 12-18-2009, 10:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1