J
jwcorn
I work for an international company and am constantly faced wit
spreadsheets of financial data supplied in one currency that must b
totally converted to another.
Duplicating the spreadsheet and building a formula in each cell tha
refers to a "seed" cell with the conversion rate is extremely tim
consuming, and must be duplicated each time a new original sheet i
received.
As far as I know, the Euro conversion function only works for th
companies actually involved in the Euro community, and can't be use
for dollars to Euros, or Pesos to Pounds.
Conceptually, I'm looking for a way to multiply every cell with number
in it by a conversion rate, without wiping out the formating an
totalling formulas as they exist in the original.
Is there an easier way
spreadsheets of financial data supplied in one currency that must b
totally converted to another.
Duplicating the spreadsheet and building a formula in each cell tha
refers to a "seed" cell with the conversion rate is extremely tim
consuming, and must be duplicated each time a new original sheet i
received.
As far as I know, the Euro conversion function only works for th
companies actually involved in the Euro community, and can't be use
for dollars to Euros, or Pesos to Pounds.
Conceptually, I'm looking for a way to multiply every cell with number
in it by a conversion rate, without wiping out the formating an
totalling formulas as they exist in the original.
Is there an easier way