Forum Discussion
VBA IF STATEMENTS
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.
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.
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.
Hi Philip
Please see attached.
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,
Your workbook works great. If I may offer two suggestions though. The drawback to the way your data validation dropdown is referenced, is that you have to manually update the reference each time you add a row normally, by pressing Tab from the bottom right cell of the table. You could create a named range using the table column, that you can then reference in the data validation which will not have to be updated. If you right click in the table, and select insert row, this isn't an issue, but one of the reasons I like tables, is that you can enter info and just keep tabbing to keep going on to the next row. I would also unlock the 2 dropdown cells, and protect the sheet. I've probably over-analyzed this, but it comes from having to un-break forms that I've created for others.
