Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using formulas from other workbooks
We have a group of formulas that we always add to a certain spreadsheet.
Right now, we either retype the formulas or try to copy them from another sheet (although at times it will only copy the value, not the formula itself). Is there a way to store a given formula or multiple formulas in a way to copy it into a new spreadsheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using formulas from other workbooks
You could use macros. But here is a simple way:
Open the worksheet with the required formula Click on the cell with the formula Use the mouse to highlight the formula in the Formula Bar Use CTRL+C to copy VERY IMPORTANT: press ESC key Move to new worksheet, locate required cell, use CTRL+V to paste the formula Alternatively: copy the cells, move to new worksheet; use Edit | Paste Special and specify Formulas best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave" wrote in message ... We have a group of formulas that we always add to a certain spreadsheet. Right now, we either retype the formulas or try to copy them from another sheet (although at times it will only copy the value, not the formula itself). Is there a way to store a given formula or multiple formulas in a way to copy it into a new spreadsheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
using formulas from other workbooks
I there a way to store the formula somewhere to use it vs. having to find
another similar version of the sheet and copy and paste? "Bernard Liengme" wrote: You could use macros. But here is a simple way: Open the worksheet with the required formula Click on the cell with the formula Use the mouse to highlight the formula in the Formula Bar Use CTRL+C to copy VERY IMPORTANT: press ESC key Move to new worksheet, locate required cell, use CTRL+V to paste the formula Alternatively: copy the cells, move to new worksheet; use Edit | Paste Special and specify Formulas best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave" wrote in message ... We have a group of formulas that we always add to a certain spreadsheet. Right now, we either retype the formulas or try to copy them from another sheet (although at times it will only copy the value, not the formula itself). Is there a way to store a given formula or multiple formulas in a way to copy it into a new spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas between workbooks | New Users to Excel | |||
Display 2 formulas from source workbooks to destination workbooks | Excel Discussion (Misc queries) | |||
formulas in worksheets/workbooks | Excel Worksheet Functions | |||
How do I compare FORMULAS in two workbooks | Excel Discussion (Misc queries) | |||
Filling Formulas Across Workbooks | Excel Discussion (Misc queries) |