+ Reply to Thread
Results 1 to 10 of 10

Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    I have been searching for this for whole day and since my vba knowledge is not that great, I am unable to make this thing happen. What I am looking to do is I have a sheet 1 with 4000 records, and sheet 2 contains regular updates that we do.

    I am looking to find cell vaule of Column A value of Sheet 2 in Column M of Sheet 1 and if it is found then replace Column B and C for the respective row in Column M.

    For e.g. In the sample sheet below, Shipment No and Shipment Date needs to be updated in Sheet 1, for the specific no. of items that are now updated in sheet 2. The unique column between two sheets is Document which is Column M in Sheet 1 and Column A in Sheet 2.

    On a regular basis there are 3800-4000 permanent items in sheet 1, sheet 2 just contains shipment updates which are 30-50 daily.

    Any help in this regard is highly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,222

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    02-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Quote Originally Posted by Mumps1 View Post
    Try:
    Please Login or Register  to view this content.
    Thanks a ton, this works smoothly, you saved me!

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,222

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    My pleasure.

  5. #5
    Registered User
    Join Date
    02-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Is it possible, to modify the macro to add a condition that if the shipment no is same as new one, don't change the date.

  6. #6
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,222

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Try:
    Please Login or Register  to view this content.

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,308

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Just for the fun of other options...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  8. #8
    Registered User
    Join Date
    02-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    This works wonderfully! Thank you very much!

    Quote Originally Posted by Mumps1 View Post
    Try:
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    02-01-2013
    Location
    india
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    Thank you very much for this!

    Quote Originally Posted by sintek View Post
    Just for the fun of other options...
    Please Login or Register  to view this content.

  10. #10
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010
    Posts
    7,222

    Re: Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2

    You are very welcome.

+ 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. Multiply two columns and then sum based on multiple sheet in the same column
    By hkbhansali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2020, 11:40 AM
  2. Macro for find and replace columns from one sheet to another
    By dorabajji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2019, 07:44 PM
  3. [SOLVED] Ranking formula based on values in multiple columns taken from a different sheet
    By m_t in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-15-2016, 03:52 PM
  4. [SOLVED] how to create UDF for multiple substitutions; find & replace values are in another sheet
    By ballroomcpa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-06-2015, 01:32 AM
  5. Multiple Find/Replace on a specified sheet and outputtingin a separe sheet
    By scfn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2013, 07:27 AM
  6. Multiple find and replace from Glossary sheet to the active sheet
    By Chandru71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2011, 12:34 PM
  7. Find and replace columns with others of another sheet
    By Costasg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2011, 11:32 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