| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 -- |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula and get value instead | Excel Discussion (Misc queries) | |||
| Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) | |||
| How to copy cells with keeping exact formula intact | Excel Discussion (Misc queries) | |||
| how can i copy formula? | Setting up and Configuration of Excel | |||
| copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
Linear Mode
