+ Reply to Thread
Results 1 to 4 of 4

Replace values in other tab with 1 click

  1. #1
    Registered User
    Join Date
    07-14-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Replace values in other tab with 1 click

    Hi all,

    I've two tabs in my excelsheet (Sheet1 and Sheet2).
    Now i have to match the ID's from both tabs, and then populate the values from Sheet1 column B, to Sheet2 column B (based on the ID).

    If the ID don't match then ignore row in Sheet1.

    Sheet1: https://i.stack.imgur.com/GjMdv.png
    Sheet2: https://i.stack.imgur.com/Ebdcu.png

    I have to implement this with one button. So when i click on the button, the values must be populated to Sheet B.

    Hope someone can help me. Thanks in advance

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Replace values in other tab with 1 click

    You could run a dictionary on Sheet1 and write the items from 1 to matches on 2

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-14-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    2

    Re: Replace values in other tab with 1 click

    Thanks for you reply. I've attached a sample workbook.

    Thanks in advance.
    Attached Files Attached Files

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Replace values in other tab with 1 click

    Try this:

    Please Login or Register  to view this content.

+ 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. Excel 2010 Double click not work ? since replace PC .
    By ks1102 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2016, 03:29 AM
  2. [SOLVED] VBA Code replace old values to new values depends upon column values
    By johnlara in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2015, 08:19 AM
  3. Replace numbers when click
    By paulocsm in forum Excel General
    Replies: 1
    Last Post: 10-23-2015, 10:35 AM
  4. "Find and Replace" missing the ability to replace values?
    By dylanemcgregor in forum Excel General
    Replies: 6
    Last Post: 06-05-2013, 01:13 AM
  5. Replies: 1
    Last Post: 01-14-2013, 04:01 AM
  6. Can I replace different urls in selected column with "Click Here" with a Macro?
    By nono77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2011, 09:47 AM
  7. Replace Right-Click menu
    By bstubbs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2009, 04:02 PM

Tags for this Thread

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