If the new book is to be is identical copy of the old, why not just open the
old one and save it under another name?

--
Ian
--
"excel _ help for the hopeless, please" <excel _ help for the hopeless,
wrote in message
...
For reasons i won't go into, i have to transfer hundreds of cells from one
workbook to another. each one of these cells contains a formula

ex:
"=SUM(IF(Production!$I$2:$I$573="HM37",IF(Producti on!$H$2:$H$573="AP",IF(Production!$S$2:$S$573="36H ",IF(Production!$D$2:$D$573="X",Production!$Q$2:$Q $573,0))),0))-SUM(IF(Production!$I$2:$I$573="HM37",IF(Production !$H$2:$H$573="AP",IF(Production!$S$2:$S$573="36H", IF(Production!$E$2:$E$573="X",Production!$Q$2:$Q$5 73,0))),0))"

the new workbook is an identical copy of the old one, so the references to
sheet "Production!" will still apply.
i don't understand why when i select a cell from the old workbook, and
copy
- paste it into a cell in the new workbook, why it doesn't transfer the
formula attached to it. instead it is only transferring the numerical
value
in the cell.
this goes for all types of formulas i have tried to copy-paste so far. i
have tried several of the paste special options, but none have the desired
outcome.

if you could supply any help on this issue, i would greatly appreciate it.
thank you