+ Reply to Thread
Results 1 to 6 of 6

If a cell contains text insert specific text in specific cells in row

  1. #1
    Registered User
    Join Date
    04-18-2017
    Location
    NW,UK
    MS-Off Ver
    MS Office 2013
    Posts
    89

    If a cell contains text insert specific text in specific cells in row

    Hello Everyone

    I need code for if in column B starting in cell B2 it says Comment then insert XXX in columns D,E & F on the same row and then to repeat for all rows than have Comment in column B

    Thank you in advance

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: If a cell contains text insert specific text in specific cells in row

    Couple of ways:

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-18-2017
    Location
    NW,UK
    MS-Off Ver
    MS Office 2013
    Posts
    89

    Re: If a cell contains text insert specific text in specific cells in row

    from one manc to another, awesome job, exactly what I wanted

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: If a cell contains text insert specific text in specific cells in row

    You're welcome. Thanks for the rep.


    Whereabouts? Got to be honest and say we moved from South Manchester nearly 12 months ago and now live not far from Jodrell Bank.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  5. #5
    Registered User
    Join Date
    04-18-2017
    Location
    NW,UK
    MS-Off Ver
    MS Office 2013
    Posts
    89

    Re: If a cell contains text insert specific text in specific cells in row

    I'm not that far from the Trafford center , I'm outside the ring road and Jodrell bank aint that far from me either 20/30min drive.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: If a cell contains text insert specific text in specific cells in row

    Ah, I know it ... not well, but I've travelled round there quite a bit. Got lost there only a couple of weeks ago

+ 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. VBA MAcro to clear contents of specific cells if a specific cell contains text
    By muzzareilly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2017, 12:47 PM
  2. [SOLVED] Excel VBA If a cell contains a specific text then other cells will show specific vaules
    By elleb in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-23-2017, 05:14 PM
  3. [SOLVED] VBA to Find Specific Text, then Copy range to next open cell under specific text
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2015, 10:59 AM
  4. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  5. Replies: 3
    Last Post: 07-12-2013, 09:17 AM
  6. Insert rows beneath cells containing specific text
    By adame in forum Excel General
    Replies: 2
    Last Post: 07-22-2011, 07:07 AM
  7. insert text to a specific cell
    By matthewwookie in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-26-2005, 10:05 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