+ Reply to Thread
Results 1 to 6 of 6

vba help needed for find matching cell value from another sheet and replace

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 2010
    Posts
    688

    vba help needed for find matching cell value from another sheet and replace

    Hi Folks,

    Please me with a code to find matching cell value from another sheet and replace with adjacent column values.

    Please find attached the work book and requirement.

    Thanks in advance,
    Joshi
    Attached Files Attached Files
    Last edited by krjoshi; 04-09-2017 at 06:43 AM.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,346

    Re: vba help needed for find matching cell value from another sheet and replace

    Try
    Please Login or Register  to view this content.
    Last edited by jindon; 04-09-2017 at 05:33 AM.

  3. #3
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 2010
    Posts
    688

    Re: vba help needed for find matching cell value from another sheet and replace

    Hi jindon,

    Excellent code... that is what I was looking for. Thank you so much for your time and help. If don't mind could you please tell me What I have to do if my column changed to H instead of A in mastersheet
    Last edited by krjoshi; 04-09-2017 at 06:15 AM.

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,346

    Re: vba help needed for find matching cell value from another sheet and replace

    Try change to
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 2010
    Posts
    688

    Re: vba help needed for find matching cell value from another sheet and replace

    Hi Jindon,
    The second code is simple compare to first code. Thank you so much once again.

    Joshi
    Cheers,

    Joshi
    Being with a winner makes you a winner

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,346

    Re: vba help needed for find matching cell value from another sheet and replace

    Yes and thanks for the rep.
    I've just edited my code...

+ 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. Find and Replace when needed Code
    By ulothar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-09-2017, 08:09 PM
  2. [SOLVED] Find value in separate sheet, offset and replace original cell value
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-30-2014, 07:34 AM
  3. Find & Replace Loop Help Needed
    By bryanmarks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 10:19 AM
  4. Help Needed with Find and Replace Macro
    By e30325i in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 02:49 PM
  5. Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  6. Replies: 7
    Last Post: 08-23-2012, 05:25 AM
  7. Find matching cell in other sheet and copy cell from different column
    By level3ninja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2011, 03:29 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1