match and replace cell

  1. C

    Macro to match specific value in one sheet and replace the entire row value in other sheet

    I have two different sheets - 1) “Working” 2) “data” Working sheet has data in column from 1 to 14 , 14th column has unique values like ABC, XYZ ,LMN and so on I need a macro to find the unique value from working sheet in Data sheet if the unique value matches then macro should copy first 5...
  2. S

    Find and Replace Many from Many

    This is killing me! Ok, so not really. :) I searched this and other forums and haven't quite found the solution that works yet. I tried Kutools and almost got it, but the find/replace feature there didn't account for 44 not being the same as 444, etc and as soon as it hit the first 44, it...
  3. S

    Multiple WB with Multiple Sheets - Need VBA help with matching numeric value in Master and then Copying and Pasting cell contents

    Good Morning All! I have a good one that I am attempting to figure and then solve using VBA in Excel 2010. 11 WB's - 1 Master and 10 others which need to be updated. Master WB has 1 Sheet. Each of the other WB's contains multiple sheets. Each sheet in the WB's is laid out the same way...
  4. S

    Match and replace cell from another sheet

    Question: I have two sheets named Sheet1 and Sheet2. Sheets looks like this: Sheet1 A ab@gmail.com je@yahoo.com gy@hotmail.com ob@outlook.com vh@hotmail.com nk@ymail.com Sheet2 A ob@outlook.com je@yahoo.com nk@ymail.com Here is what I want: If any cell in Sheet2 Column A = Any cell in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top