Results 1 to 3 of 3

Replace old value with new value, referenced from prefix values

Threaded View

  1. 02-21-2019, 09:53 AM #1
    Eduards
    Eduards is offline
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Replace old value with new value, referenced from prefix values

    I need to replace the A column values with the I column values. Both tables have barcodes, all barcodes are unique because it identifies the product codes. But the two tables will have a match e.g. A1 is same as I1 becasue E1 and K1 are same barcodes and that is the same product code. Left column is just old version of product codes and the right one will be the new ones. Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] add prefix to number based on validation from other data if found prefix 0, do nothing
    By oeyandyprawira in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2018, 11:52 AM
  2. replace some part of text in cell with prefix
    By sepreta in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2017, 06:04 AM
  3. [SOLVED] Replace hyphenated prefix of concatenated columns removing to much
    By capson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-14-2015, 05:02 PM
  4. [SOLVED] Prefix macro for certain values
    By John Swift in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2015, 02:53 PM
  5. [SOLVED] How to replace dash in a column of numbers with a space and add a prefix
    By HH61 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-04-2014, 02:33 PM
  6. [SOLVED] Macro to Find & Replace existing formula with text in referenced cells
    By sonyap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 10:39 AM
  7. Replace one prefix with another prefix
    By uglyduck in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2010, 08:24 PM

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