+ Reply to Thread
Results 1 to 16 of 16

Match name in 1 column with another for a dynamic range

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Match name in 1 column with another for a dynamic range

    So I have this particular set of data in which Column A contains the full name of the kids, Column D contains the first name of the kid, Column E contains the amount they have been charged.

    I want the name of the kid in column A to come in place of the numbers below them and in sync with the name in Column D, now I could just copy paste the entire range 1 row below, but there are kids of the same family and they have 2 names together example on row 18,19 so If I try to copy paste it will not fit perfectly...

    I literally have no Idea how to go about it hence have no prepared code on it..

    If you can solve this issue for me, you're god. Simple.
    Attached Files Attached Files
    Last edited by AnirudhC; 04-22-2017 at 09:21 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,920

    Re: Dynamic range, ample clauses can't think of anything!

    title updated...
    Last edited by protonLeah; 04-22-2017 at 01:47 AM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Dynamic range, ample clauses can't think of anything!

    Quote Originally Posted by protonLeah View Post
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Changed the title thanks!

  4. #4
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,956

    Re: Match name in 1 column with another for a dynamic range

    Hi AniRudHc

    A bit of a long method, but perhaps someone else will improve the code.
    There are a few errors in your worksheet so had to work around them.
    The only way i could figure this out was to insert a New column for results and then delete the old column.... Anyway give it a try.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Sintek; 04-22-2017 at 06:22 AM.
    Good Luck...
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Match name in 1 column with another for a dynamic range

    AnirudhC

    This is how I read your problem.
    You have few data spelled wrong, e.g. Angayarlcanni, Aathmika vs Aathimika.
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    Hi Sintek, Thanks for the reply.
    Your code works great! just the way I want it too, but there is a problem, The code is not working on the first and the last name? That is going to get me into to trouble if I miss to bill 2 kids!

    Thanks for the help though much appreciated.

  7. #7
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    Hi Jindon, Thanks for the reply.
    Your code works perfectly too! But it not picking up the full name of the kids, also on rows 114-118 there are 4 billing amounts, after running the code only 2 are left.. If we could get around these 2 problems it would be much appreciated!

    Thanks for the help though much appreciated.

  8. #8
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Match name in 1 column with another for a dynamic range

    Try this one then
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    WORKED LIKE A CHARM! you're god. 'nuf said.

    Also it is not dependant on the sheet or workbook name or number of lines right? just the region has to start on A6?

  10. #10
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Match name in 1 column with another for a dynamic range

    It is based on the layout of the workbook that you uploaded.
    It works on ActiveSheet, so doesn't matter of the sheet name however, Row 5 must be completely blank.

  11. #11
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    OW shizzz repeated names takes the second name to the first one? "Blake" for instance, there are 2 blakes, second ones billing amount is going to the first blake..

  12. #12
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Match name in 1 column with another for a dynamic range

    This will list up when irregular happens in col.D at the bottom...
    Please Login or Register  to view this content.
    Last edited by jindon; 04-22-2017 at 09:13 AM. Reason: "Blake" for instance, there are 2 blakes, second ones billing amount is going to the first blake

  13. #13
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    Not working, the billing amount of second one still going to the first blake.

  14. #14
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,834

    Re: Match name in 1 column with another for a dynamic range

    Copy again. The code has been edited.

  15. #15
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2016
    Posts
    24

    Re: Match name in 1 column with another for a dynamic range

    Worked! Thank you so much!!

  16. #16
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,956

    Re: Match name in 1 column with another for a dynamic range

    Quote Originally Posted by AnirudhC View Post
    Hi Sintek, Thanks for the reply.
    Your code works great! just the way I want it too, but there is a problem, The code is not working on the first and the last name? That is going to get me into to trouble if I miss to bill 2 kids!

    Thanks for the help though much appreciated.
    Thanks for feedback....Needed to change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Glad jindon got it right

+ 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. Conditional Clauses
    By rdtanner in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-28-2013, 10:50 PM
  2. How to combine results of several if clauses in one formula?
    By DaJackal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2013, 10:01 PM
  3. Using clauses if theres growth?
    By omgwtf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2013, 01:42 PM
  4. If clauses
    By michelle b in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-22-2013, 04:41 PM
  5. issue with if clauses
    By Wyn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2013, 01:16 PM
  6. Replies: 2
    Last Post: 10-05-2012, 10:10 AM
  7. Do While only evaluating one of two clauses?
    By NickSlash in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-30-2012, 10:13 AM
  8. Excel Formula with two clauses
    By jmrd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2006, 10:45 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