+ Reply to Thread
Results 1 to 2 of 2

VBA - Match and replace values on another sheet

  1. #1
    Forum Contributor
    Join Date
    12-06-2021
    Location
    Fort Lauderdale, Florida. United States
    MS-Off Ver
    365
    Posts
    143

    VBA - Match and replace values on another sheet

    Hello!

    I have a workbook with 2 sheets.

    1. "Source Sheet"
    2. "Edit Sheet"

    On "Edit Sheet" i have the =UNIQUE formula that is replicating the Source Sheet

    My Goal: Use the Edit Sheet to filter column D (which contains an ID number) for a 1 or more values, then switch over to Source Sheet and replace the row contents with a 0 on the row where that ID number is found.

    I plan to put a button on the Edit Sheet which will run this proposed macro, but have it warn the user that something needs to be filtered prior to running the code, as they could potentially wipe-out the entire sheet otherwise!

    Any help would be appreciated! Sample spreadsheet attached!
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: VBA - Match and replace values on another sheet

    The sheets in your code does not match the sheets in the workbook.
    Your code is looping through column A not column D
    There are no duplicates in Column D

+ 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. [SOLVED] replace values into column from sheet to another after matched
    By Alaa-A in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-16-2021, 03:42 AM
  2. [SOLVED] copy specific columns and replace values & calculate values from sheet to another
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2021, 04:30 AM
  3. [SOLVED] Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2
    By adblog3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2020, 01:49 PM
  4. Find and Replace - Replacing Values on One Sheet with Values from Another
    By yoanakunova in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2019, 12:11 PM
  5. Replace all sheet values with their RANK
    By Lagrange17 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2014, 10:15 AM
  6. Help need to table value should match and replace to another sheet
    By amiable in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2013, 12:28 AM
  7. Macro for match and replace cell values between 2 workbook
    By ramton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2012, 01:06 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