Automated Journal Entry template

[fiction]

Hi all,

Is it possible to make a Journal Entry template on Excel such that:

- One page has a list of companies with General Ledger accounts
- The other page as the input template

So for example, if I typed in / selected Company A from a dropdown, Excel would automatically pull the correct coding information (to eliminate manually selecting and figuring out the account info).


Thanks so much for all your help!!