Closed Thread
Results 1 to 3 of 3

Two various applications of VBA code - help needed

  1. #1
    Registered User
    Join Date
    04-27-2020
    Location
    Honolulu
    MS-Off Ver
    2017
    Posts
    5

    Two various applications of VBA code - help needed

    Hi guys,

    I would like to ask for advice that would help me to get TWO options very similar codes which do the following:
    1) Code (perhaps do until loop?), which splits the data from column “S” of the sheet “Address” and populates these unique 1-5 string location in between the column J and N of the sheet “destination”, where each string of the 1-5 string address is being placed into separate (relevant) column, while each unique address sits on the separate line. As implied, the code should run until it inspects all the strings within the relevant row of the cell S within “Address” sheet. The example of the possible structure of 3-5 string locations can be found attached (sheet “address”) along with how these should be populated (sheet “destination”).

    2) Code which does the same as above, BUT treats the string containing street details as “as unstructured” placing this type of input in one column – i.e. disregarding the need for a split due to variability of the format and lacking pattern. The “classic” 1-3-string input (i.e. country, region, city OR city, country OR country only) shall still be populated into relevant cells. Please see the example in “destination 2” tab.


    Please note the “location country should always be populated (i.e. in scenario 1 as well as 2) as this is a mandatory/structured input (always sits at the end of the string). Also, please note the attached is just sample and the code should be dynamic (i.e. applicable to bigger data samples)

    Attached please see the examples for better illustration.

    Kind regards,

    S
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    16,646

    Re: Two various applications of VBA code - help needed

    Different user names but the same question.

    https://www.excelforum.com/excel-pro...ing-split.html

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,087

    Re: Two various applications of VBA code - help needed

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue in the original thread under the other user name.

    You will need to contact an administrator and ask them to close one of your accounts. Thank you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Code Needed On 250 lines, code changes on each line, Eaiser way to do this?
    By John37obc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2020, 10:51 AM
  2. [SOLVED] Password code designed for 5 Users - NAVIGATION Help Needed! - CODE Issue!
    By JJFletcher in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-09-2014, 10:46 AM
  3. VBA code needed
    By JonathanB2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2014, 01:16 AM
  4. VBA code needed deserately for similar cells but do not know how to copy code!
    By Gunner_gav in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-19-2013, 03:39 AM
  5. [SOLVED] VBA code help needed
    By Martin in forum Excel General
    Replies: 3
    Last Post: 04-28-2006, 04:35 AM
  6. [SOLVED] VB code help needed
    By Phil in forum Excel General
    Replies: 3
    Last Post: 11-27-2005, 06:25 PM
  7. Code help needed.
    By dcleave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2005, 02:11 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