EXCEL MACRO: Find & Replace based on sheet
Results 1 to 4 of 4

Thread: EXCEL MACRO: Find & Replace based on sheet
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2010
    Location
    Singapore
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default EXCEL MACRO: Find & Replace based on sheet

    I need some help again :D


    I need to find from Column A2 below from Data (sheet)
    and replace from Column A2 below keyword (Sheet)

    replace format as what found in Keyword sheet


    A1 is header

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Location
    Singapore
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL MACRO: Find & Replace based on sheet

    oh my sound strange.. i think i got it wrong?

    A1 is header
    My result sheet is at DATA sheet A2 below

    I suppose need to had 2 table on KEYWORD Sheet?

    Table 1 (A2) is the text which found at DATA Sheet?
    Table 2 (B2) is the text to be replaced?
    If cannot find, just ignore and process the next (no changed done)
    Last edited by harky; Aug 23rd, 2019 at 10:53 AM.

  3. #3
    Board Regular
    Join Date
    Apr 2010
    Location
    Singapore
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL MACRO: Find & Replace based on sheet

    Data sheet
    A1 (Header) Result
    859 859_
    859A 859A_

    Keyword sheet
    Find (A1) Replace (B1)
    859 859_
    859A 859A_

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Location
    Singapore
    Posts
    229
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: EXCEL MACRO: Find & Replace based on sheet


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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