+ Reply to Thread
Results 1 to 13 of 13

Insert value if specific word appears in that row

  1. 10-12-2012, 06:03 PM #1
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Insert value if specific word appears in that row

    Hi,

    I'm trying to write a value to a cell 15 columns along if a specific word exists in column I.

    Please Login or Register  to view this content.
    Thanks for any help,

    David
    Reply With QuoteRegister To Reply
  2. 10-12-2012, 06:06 PM #2
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    Hi David,

    From your post I think you want to check all of column I for a specific word and if so, go 15 columns to the right and put the value.

    Is this correct?

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 10-12-2012, 06:10 PM #3
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    Untested:

    Please Login or Register  to view this content.
    Last edited by abousetta; 10-15-2012 at 01:11 PM.
    Reply With QuoteRegister To Reply
  4. 10-12-2012, 06:17 PM #4
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Insert value if specific word appears in that row

    Yes, what you stated was correct, I will test the script above and let you know.

    Thanks,

    David
    Reply With QuoteRegister To Reply
  5. 10-15-2012, 10:31 AM #5
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Insert value if specific word appears in that row

    Hi abousetta,

    Sorry for the delay in testing, but it did not work.

    Thanks anyway.

    David
    Reply With QuoteRegister To Reply
  6. 10-15-2012, 10:56 AM #6
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    post a sample
    Reply With QuoteRegister To Reply
  7. 10-15-2012, 11:25 AM #7
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Insert value if specific word appears in that row

    Here is the file attached with macro.

    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 10-15-2012, 12:00 PM #8
    Oredigger90
    Oredigger90 is offline
    Registered User
    Join Date
    08-27-2012
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    57

    Re: Insert value if specific word appears in that row 

    Please Login or Register  to view this content.

    This worked for me
    Piggy
    Reply With QuoteRegister To Reply
  9. 10-15-2012, 01:11 PM #9
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    Sorry about that. LR was wrong. It should work now.

    abousetta
    Reply With QuoteRegister To Reply
  10. 10-15-2012, 01:36 PM #10
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Insert value if specific word appears in that row

    Thank you both, but It still does not work for me. The file I have uploaded is in Excel 2003 so maybe my version is not compatible with your script.
    Reply With QuoteRegister To Reply
  11. 10-15-2012, 01:47 PM #11
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    Have a look at the attachment.

    abousetta
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 10-15-2012, 01:55 PM #12
    djfscouse
    djfscouse is offline
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Re: Insert value if specific word appears in that row

    Perfect! Thanks for all your help.
    Reply With QuoteRegister To Reply
  13. 10-15-2012, 02:04 PM #13
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Insert value if specific word appears in that row

    Glad I could be of assistance.

    Good luck.

    abousetta
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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