M
Mike
Im trying to create an invoice template with an option to change currencies,
via a drop down list - only two values, USD or GBP
Once the user selects either USD or GBP, the spreadsheet will then show USD
[or GBP] in the unit price and sub-total columns and it will also alter bank
details [sort code, account number, swift code] further down the template.
I've got it working using IF commands but I have to type in either USD or
GBP, whereas I'd prefer to select it from a list.
Thanks in advance.
I'm using a slightly amended copy of the - Sales invoice with tax and
shipping and handling calculations template - from the microsoft website.
via a drop down list - only two values, USD or GBP
Once the user selects either USD or GBP, the spreadsheet will then show USD
[or GBP] in the unit price and sub-total columns and it will also alter bank
details [sort code, account number, swift code] further down the template.
I've got it working using IF commands but I have to type in either USD or
GBP, whereas I'd prefer to select it from a list.
Thanks in advance.
I'm using a slightly amended copy of the - Sales invoice with tax and
shipping and handling calculations template - from the microsoft website.