Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Newbie in VBA - Help to find value if two other conditions are met

  1. #1
    New Member
    Join Date
    Mar 2016
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Newbie in VBA - Help to find value if two other conditions are met

    Hi All,

    Well I am a complete newbie on VBA and am learning on the go at the moment. I do have a "little" issue that I cannot figure out:

    So I have a workbook containing quite a lot of formulas already (these are working fine) but there's one last bit I cannot seem to resolve.

    The sheet is as follows (please note this is just partial data):

    Management:6
    Management:7
    ACCOUNT_NAME
    ORG 6 Update
    Corp Code
    Account Type
    Account Number
    12345678
    12345678- Account Name 1
    Account Name 1 -
    ABC123
    CORPORATE
    12345678
    87654321
    87654321 - Account Name 2
    Account Name 2
    -
    ABC123
    ACCOUNT
    87654321
    98765432 98765432 - Account Name 3 Account Name 3 - DEF456 CORPORATE 98765432
    23456789 23456789 - Account Name 4 Account Name 4 - DEF456 ACCOUNT 23456789


    Column A and G have the same value for now, column B is a concatenate of G and C. What should happen is following: Column A should reflect the account number of of the Corporate account type if the Corp Code is the same. I cannot figure out how to make this going (there are about 600 lines with multiple Corp Codes, Account Types and Account Numbers). Which is why I turn to you as you have been helpful to me creating this file so far (loving the forum!)

    Please help my poor brain with this problem

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    Column A should reflect the account number of of the Corporate account type if the Corp Code is the same.

    what does this mean ? show us a desired output table

  3. #3
    New Member
    Join Date
    Mar 2016
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    Quote Originally Posted by oldbrewer View Post
    Column A should reflect the account number of of the Corporate account type if the Corp Code is the same.

    what does this mean ? show us a desired output table
    Hey Oldbrewer,

    Sorry if I wasn't clear

    So the desired output should be:

    Management:6 Management:7 ACCOUNT_NAME ORG 6 Update Corp Code Account Type Account Number
    12345678 12345678- Account Name 1 Account Name 1 - ABC123 CORPORATE 12345678
    12345678 87654321 - Account Name 2 Account Name 2 - ABC123 ACCOUNT 87654321
    98765432 98765432 - Account Name 3 Account Name 3 - DEF456 CORPORATE 98765432
    98765432 23456789 - Account Name 4 Account Name 4 - DEF456 ACCOUNT 23456789


















    I hope that the additional table helps making it clear! If not, I'll try to write it down again in other terms.

    Thanks again!

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    9,189
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Newbie in VBA - Help to find value if two other conditions are met

    say in words what information you seek and where you want it

    I cannot see where row 2 of your output comes from

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com