Forum Discussion

LaToya Phillip's avatar
LaToya Phillip
Copper Contributor
Aug 28, 2018
Solved

VBA IF STATEMENTS

I am trying to create IF VBA statements.  FYI-I have no knowledge of writing VBA language.    The goal is to create a template for users to use when when requesting wire transfers.  On this templat...
developer
excel
Macros and VBA
  • Philip West's avatar
    Philip West
    Aug 28, 2018

    hia,

    thanks for that. I've attached what I think solves your problem.

     

    on sheet1 i've added 2 tables, one is called tbl_to and one is called tbl_from that contains the details of the accounts.

     

    Then on your template i've added the index match for the various rows. If you change the names you should see the account details change.

Philip West's avatar
Philip West
Iron Contributor
Aug 28, 2018

Does it have to be VBA? From your description it sounds like it could all be achieved by having a table with the details in and then using more vlookups or index(match()).

LaToya Phillip's avatar
LaToya Phillip
Copper Contributor
Aug 28, 2018

I am not familiar with the index/match.  I tried to do some research on it but was unsuccessful with making it work for my situation do to lack of knowledge.

  • Philip West's avatar
    Philip West
    Iron Contributor
    Aug 28, 2018

    Hi LaToya, no worries..

     

    It would help a little if you could upload an workbook that shows the structure of your data and what the end result should look like.

     

      • Philip West's avatar
        Philip West
        Iron Contributor
        Aug 28, 2018

        hia,

        thanks for that. I've attached what I think solves your problem.

         

        on sheet1 i've added 2 tables, one is called tbl_to and one is called tbl_from that contains the details of the accounts.

         

        Then on your template i've added the index match for the various rows. If you change the names you should see the account details change.

Resources