how to copy formula from one workbook to another

[psp]

Hi!

I have a blank workbook containing many formulas and many worksheets. I use
this to create a new workbook everymonth and enter data. After a while, I
found a way to improve in a subset of formulas. How can I go back and reapply
these formula to the entire workbook (including all worksheets, some of them
are identical but others are different) without doing lot of manual work?

thank you,

prashant
--

[hideki]

How about the paste special? It didn't work or not likely what you were looking for?

[psp]

Hi!

The Paste special only works for one worksheet not for the whole workbook.
The best way I found is to create a template file (.xlt) and save it.

thanks,

prashant.
--
Excel is my life at work


"hideki" wrote:

>
> How about the paste special? It didn't work or not likely what you were
> looking for?
>
>
> --
> hideki
> ------------------------------------------------------------------------
> hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
> View this thread: http://www.excelforum.com/showthread...hreadid=400948
>
>