+ Reply to Thread
Results 1 to 7 of 7

Loop for Cell-to-cell comparison (Complex)

  1. #1
    Registered User
    Join Date
    04-03-2017
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    10

    Loop for Cell-to-cell comparison (Complex)

    Hi guys,

    So I have two sheets involved in this process; USERFORM and DATA (source of all needed information for USERFORM)

    Now, in the USERFORM, I have 2 important columns; COUNTRY and BUSINESS TYPE

    It looks like this:
    USERFORM

    COUNTRY----------------BUSINESS TYPE
    Algeria--------------------Local
    Morocco------------------International
    Algeria--------------------International

    My problem is this; I'm having trouble creating a loop that will get ALL the business types associated with one country in the DATA sheet and then throw all the distinct values to the corresponding BUSINESSTYPE row (as data validation lists) in the USERFORM sheet. So far, this is what I've come up with;

    Please Login or Register  to view this content.
    Thanks in advance, guys. Any and every help will be most appreciated.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Loop for Cell-to-cell comparison (Complex)

    Best to post a small example file with before and after sheet included so we have something to work with.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    04-03-2017
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    10

    Re: Loop for Cell-to-cell comparison (Complex)

    Here it is, although it's just a dummy sheet. I've placed a textbox in it to describe what I need.

    Attached Files Attached Files

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Loop for Cell-to-cell comparison (Complex)

    Sorry, but did you post correct file ? All I see is a sheet with a PT in it.

  5. #5
    Registered User
    Join Date
    04-03-2017
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    10

    Re: Loop for Cell-to-cell comparison (Complex)

    Sorry about that. How about this screencap instead?
    Attached Images Attached Images

  6. #6
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Loop for Cell-to-cell comparison (Complex)

    This is what you write in your first post.
    So I have two sheets involved in this process; USERFORM and DATA (source of all needed information for USERFORM)
    I don't see the Data sheet where all the information is supposed to be. How can I help you if you don't provide the necessary information ????

  7. #7
    Registered User
    Join Date
    04-03-2017
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    10

    Re: Loop for Cell-to-cell comparison (Complex)

    It's here ^_^ Sorry, kinda lost myself while trying to find out ways...
    Attached Images Attached Images

+ 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. Complex Table Comparison
    By jordanmh84 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-01-2016, 01:31 PM
  2. Check contents of cell against an adjacent cell and return comparison?
    By Nate Westcott in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2015, 01:05 PM
  3. Complex Comparison formula between 2 separate tables
    By AJChappy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2015, 01:22 PM
  4. [SOLVED] Complex comparison of columns (help!)
    By phil.aubert in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 07-07-2014, 05:03 PM
  5. [SOLVED] Complex Sheets Comparison
    By CatherineAmerica568 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-04-2013, 09:05 PM
  6. [SOLVED] Complex Comparison forumula - Help
    By Rjwilliams93 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-08-2013, 06:58 PM
  7. Comparison for best results to complex for my small brain
    By gordon.worswick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-04-2013, 05:59 AM

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