Hi All,
I don't often have to work with currencies with excel so any help would be appreciated,
I have a link to the web creating a table price list, and then I've converted that data from the table to be able to sum it using the formula shown,
I have then created another link to a currency converter,
How can I apply the conversion to the data in column K:L?
I'd like to be able to convert the currencies in K:L to any other currency I would assume that K:L would remain as they are and then another column M? would have the selected currency value?
Any help or advice would be great thanks all,
I don't often have to work with currencies with excel so any help would be appreciated,
I have a link to the web creating a table price list, and then I've converted that data from the table to be able to sum it using the formula shown,
I have then created another link to a currency converter,
How can I apply the conversion to the data in column K:L?
I'd like to be able to convert the currencies in K:L to any other currency I would assume that K:L would remain as they are and then another column M? would have the selected currency value?
Any help or advice would be great thanks all,