how to copy formula from one workbook to another

P

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
--
 
H

hideki

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

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