+ Reply to Thread
Results 1 to 5 of 5

Need to Find one of possible enteries out of a larger number of entries and move to next

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Denver
    MS-Off Ver
    2013
    Posts
    2

    Need to Find one of possible enteries out of a larger number of entries and move to next

    I have a list of people I need to find within a larger list of people, however the larger list is populated based on assignments and are populated in cell h2 through m2 , the result needs to be pasted in g2 then move to next and find result in h3 to m3 paste in g3 etc. There are 20 different options in h2 through m2 and I only have 10 that I have the option for responses from. My original idea was to make an If Else and move horizontally running an instance in each cell until it found a result and moving down a row starting process over until the end. Any help would be greatly appreciated

    Sub assignment()

    Dim assignment As String
    Dim i As Integer
    Dim j As Integer

    assignment = Range("h2").Value

    Do Until i > 2725
    Do Until j > 13

    Range("H2").Offset(0, 1).Select

    If aba = "Name1" Then
    result = "Name1"

    ElseIf aba = "Name2" Then
    result = "Name2"

    ElseIf aba = "Name3" Then
    result = "Name3"

    ElseIf aba = "Name4" Then
    result = "Name4"

    ElseIf aba = "Name6" Then
    result = "Name6"

    ElseIf aba = "Name7" Then
    result = "Name7"

    ElseIf aba = "Name8" Then
    result = "Name8"

    ElseIf aba = "Name9" Then result = "Name9"

    End If
    Range("G2").Value = result

    Range("H2").Offset(1, 0).Select

    Loop
    Range("G2").Offset(1, 0).Select
    Loop

    End Sub
    Last edited by bfresh84; 07-16-2015 at 11:08 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need to Find one of possible enteries out of a larger number of entries and move to ne

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Need to Find one of possible enteries out of a larger number of entries and move to ne

    Submit an example workbook with before and after demonstrations of your objective.

  4. #4
    Registered User
    Join Date
    07-13-2015
    Location
    Denver
    MS-Off Ver
    2013
    Posts
    2

    Re: Need to Find one of possible enteries out of a larger number of entries and move to ne

    Thank you very much! I hadn't messed around with Select Case yet, still new at this

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Need to Find one of possible enteries out of a larger number of entries and move to ne

    You're welcome. Glad to help out and thanks for the feedback.

+ 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. find lastrow and chart last 200 enteries
    By NoahJEck in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2015, 01:21 PM
  2. Replies: 3
    Last Post: 04-02-2014, 02:44 PM
  3. Replies: 3
    Last Post: 03-09-2013, 06:27 PM
  4. Replies: 4
    Last Post: 11-13-2012, 02:16 PM
  5. Replies: 2
    Last Post: 04-28-2011, 02:45 PM
  6. find the larger number
    By apos1982 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2008, 06:25 AM
  7. [SOLVED] how do I find duplicate text enteries in Excel
    By Cambronze in forum Excel General
    Replies: 1
    Last Post: 08-04-2005, 04:05 AM

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