Hi
use a formula such as
='[otherbook.xls]sheet1'!A1/$A$1

where A1 stores your rate

--
Regards
Frank Kabel
Frankfurt, Germany

"macros excel... duplication and calculat" <macros excel... duplication
and schrieb im Newsbeitrag
...
I must design a workbook which can be duplicated or copied to another
workbook, as it is copied it must be divided to a rate which can be
stored in
a worksheet of the primary workbook... Is like when you want to
calculate
from Dolars to Euros.