how can I duplicate or copy a workbook then divide selected cells.

  • Thread starter macros excel... duplication and calculat
  • Start date
M

macros excel... duplication and calculat

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.
 
F

Frank Kabel

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 [email protected]> schrieb im Newsbeitrag
news:[email protected]...
 
Top