Forum Discussion
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...
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.
Hi Philip I have created a table and was using IF statements however there are multiple Transfer Funds to Agents and Transfer fund to Beneficiaries. I am only able to use the vlookup on the bank name field. Everywhere else I am using IF statements. My concern about using these formulas is for some reason a user may accidentally delete the formulas. I guess I wanted a better way to protect the information on the template.