+ Reply to Thread
Results 1 to 6 of 6

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

  1. 04-09-2017, 04:15 AM #1
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    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.
    Reply With QuoteRegister To Reply
  2. 04-09-2017, 04:46 AM #2
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    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.
    Reply With QuoteRegister To Reply
  3. 04-09-2017, 06:13 AM #3
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    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.
    Reply With QuoteRegister To Reply
  4. 04-09-2017, 06:19 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    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.
    Reply With QuoteRegister To Reply
  5. 04-09-2017, 06:39 AM #5
    krjoshi
    krjoshi is offline
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    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
    Reply With QuoteRegister To Reply
  6. 04-09-2017, 07:07 AM #6
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,516

    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 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)

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. Match 2 cell values on Sheet 1 and find two cells with same matching value on sheet 2
    By billfloyd806 in forum Excel General
    Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  6. [SOLVED] Find sting in another row on another sheet, then replace with matching cell data
    By shauncat in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1