Converting data....

M

Manos

Dear all,

i need your special knowledges for converting a table.

I have a table with special format having values for last
year data, budget and actual of this year. (3 columns) and
there are 2 columns of having as a percentage the
difference bteween thos three columns.

The values are in a local currency for each shop. i.e. USA
has dollars.
There is anyway that i can transform those values
automatically to Euro. Either by coping the tables, or
using currency converter, or doing a "tric"?

Any good suggestions?

Thanks in advance
Manos
 
F

Fred Davis

Manos,

Assuming your US$ value is in column C, in D1 type the
formula: '=C1*x' (without the ') where x is the exchange
rate, dollars to euros. Copy this formula down column D
to convert all your values in C.

Hope this helps,
Fred
 
A

A.W.J. Ales

Manos,

In an empty cell put the conversion rate $ to Euro ( something like 1,20 ?).
Copy that cell and then select the range with dollaramounts.

Then (from the menu) Edit / Paste Special / Multiply.

(This multiplies all the selected cells with the content of the copied
cell).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
M

Manos

Hello again,

Thank you falks for your ideas, but it isn't what i am
looking for.

There is any other way by usng a more automated way?
a macro, or an Add-in, or even a code in visual basic

i don't want ot spent days for changing everything.
Imagine that i am talking about 1230 sales offices all
over the world, and at list 1230 different files...

Did you have any ideas, or if you now a program that exist
in the market in order to help in a such problem?

Regards, Manos
 
H

Hardy

My suggestion would be not to format those columns to £, $ etc.

If these are in col A, have currency in col B (EUR, GBP, JPY etc.)

Then for Col C, you could have AmtEUR to have euro amounts.

Use following in Col C to convert

=IF(B2<>"EUR",A2/VLOOKUP(B2,E2:F4,2,FALSE),A2)

E2:F4 contain exchange rates vs. EUR, so 1EUR buys 1.19 USD.

E1:F4;
EUR vs.
USD 1.19
JPY 107
AUD 0.7459

Hope this help
 
H

Hardy

Tell me what was wrong with my suggestion? Sorry, I should have mad
references in vlookuo absolute;

=IF(B2<>"EUR",A2/VLOOKUP(B2,$E$2:$F$4,2,FALSE),A2)

You can copy this down as many cells as you like and alternatively hav
table read from another worksheet where exchange rates are store
centrally.

From what you say, I think you want to plug and play some add-in or VB
and not have to think, but it doesn't work like that. Keep it simple
think it through and far better that you create it, with some help
 
Top