+ Reply to Thread
Results 1 to 7 of 7

If text if found, paste/copy into column C

  1. 12-07-2012, 02:04 PM #1
    fbivens is offline
    Registered User
    Join Date
    12-07-2012
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2010
    Posts
    7

    If text if found, paste/copy into column C

    I have a macro that searches and BOLDs text using a prompt. In addition to bolding, I need to copy the text from the prompt box into Column C of the same row when found.

    Also how do I add on additional attributes such as underline and italics?

    Thank you for your help.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-07-2012, 05:03 PM #2
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,964

    Re: If text if found, paste/copy into column C 

    Please Login or Register  to view this content.
    Last edited by protonLeah; 12-07-2012 at 05:07 PM.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 12-07-2012, 11:28 PM #3
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,964

    Re: If text if found, paste/copy into column C

    deleted by bvj
    Last edited by protonLeah; 12-12-2012 at 07:01 PM.
    Reply With QuoteRegister To Reply
  4. 12-08-2012, 01:21 PM #4
    aelgadi is offline
    Registered User
    Join Date
    11-26-2012
    Location
    Kitchener, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: If text if found, paste/copy into column C

    Oh sorry I thought I'm helping. I got it now. No more contribution to any post thanks
    Reply With QuoteRegister To Reply
  5. 12-11-2012, 04:16 PM #5
    fbivens is offline
    Registered User
    Join Date
    12-07-2012
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: If text if found, paste/copy into column C

    I just tested it and found the following:

    All items are bolded, but only the first item is labeled in column c, italicized, underlined.

    I inserted the code you provided from IF to ELSE.

    I don't know how to edit the loop to label, italicize and underline all found lines.

    Thank you for your help.
    Last edited by fbivens; 12-11-2012 at 05:14 PM.
    Reply With QuoteRegister To Reply
  6. 12-12-2012, 07:20 PM #6
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,964

    Re: If text if found, paste/copy into column C

    Please post a sample to test the code on.
    Reply With QuoteRegister To Reply
  7. 12-14-2012, 07:25 PM #7
    fbivens is offline
    Registered User
    Join Date
    12-07-2012
    Location
    Albuquerque, NM
    MS-Off Ver
    Excel 2010
    Posts
    7

    Smile Re: If text if found, paste/copy into column C

    Sample workbook attached. Thank you.
    Attached Files Attached Files
    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