+ Reply to Thread
Results 1 to 8 of 8

Replace Vlookup with VBA, separate text by ">" and sort

  1. 06-22-2016, 02:10 PM #1
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Exclamation Replace Vlookup with VBA, separate text by ">" and sort

    Hi experts,
    I really need your help.

    I have an excel file with 2 sheets (attached).
    I need VBA to bring corresponding to values from sheet "Paste_from_DB" to sheet "Working". It is basically vlookup somehow replaced with VBA with condition to bring few parts of the text instead of text as a whole.
    After that I need to select row 3 and sort all data based on J3 cell from A to Z. Is it possible?
    It's more clear in excel than my explanation...
    Thanks a lot!
    Attached Files Attached Files
    Last edited by R12345; 06-22-2016 at 02:26 PM.
    Reply With QuoteRegister To Reply
  2. 06-22-2016, 02:21 PM #2
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    This is simple explanation on image:
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  3. 06-22-2016, 02:37 PM #3
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    See next code

    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  4. 06-22-2016, 02:44 PM #4
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    Thanks a lot! It's working great!
    Is there a way I can select all data from from 3 to the end and sort it based on cell J3 from A to Z?
    Reply With QuoteRegister To Reply
  5. 06-22-2016, 02:53 PM #5
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    Just managed it! Thanks!
    Reply With QuoteRegister To Reply
  6. 06-22-2016, 02:59 PM #6
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    I forgot


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 06-22-2016, 03:25 PM #7
    R12345
    R12345 is offline
    Registered User
    Join Date
    02-07-2016
    Location
    Canada
    MS-Off Ver
    13
    Posts
    65

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    Thank you so much!
    Reply With QuoteRegister To Reply
  8. 06-22-2016, 03:26 PM #8
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Replace Vlookup with VBA, separate text by ">" and sort

    You are welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"
    By savekels in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. [SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 02:11 PM
  3. [SOLVED] Doing a Find/Replace not working if "replace" text is too large
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2014, 02:52 PM
  4. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. Replace numbers with Text ("1" to "Apple", for example)
    By pilotwings64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2008, 06:56 PM
  6. How to replace "#N/A" w "0"when vlookup couldn't find the match?
    By Holly in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 06:55 PM
  7. Replace text "Smith, Joe" into "Joe Smith" for a single cell
    By flyingmachine in forum Excel General
    Replies: 6
    Last Post: 04-07-2005, 02:53 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