how to copy formula from one workbook to another
 

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

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

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