Hi,

I'm trying to create a dynamic invoice - with customer invoice addresses
changing when I change the account number [in cell c5].

Can someone advise the easiest [and simplest] way of making this happen?

Address is from B4:b7

Thanks for any help!