Populate payee banking info into payment requisition form

[nekojima]

Hello,

I am trying to automate our payment requisition form by creating another worksheet with payee banking information and will aim to have the worksheet populate on the payment requisition form in the same workbook. I currently have eight items of information for each payee, such as client number (column B, going to B24 on the form), client name (column C, going to A25, other account number (column C, going to F24) and so on.

I would like to be able to enter one number or reference to populate the payment requisition form. I'm rather lost on how to do this, but willing to learn (I added SpellNumber today in two languages) and would welcome suggestions.

Thank you,

nekojima.

 

[nekojima]

I've continued to work on this and wondering if I'm going in the right direction.

If we enter the client number in that field, and then have the other seven fields use a vlookup based on that field as a reference or search parameter, can these fields pull the necessary data from the payee bank info tab?