| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i copy values between tables using relative formulas
I've created a workbook in Excel 2007 and I'm trying to use the copy feature
to insert relative formulas into several adjacent cells by draging the relative formula one one cell into several adjacent cells. While the resulting formulas are corret the relative values are not. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i copy values between tables using relative formulas
"ther00k" wrote in message
... I've created a workbook in Excel 2007 and I'm trying to use the copy feature to insert relative formulas into several adjacent cells by draging the relative formula one one cell into several adjacent cells. While the resulting formulas are corret the relative values are not. I think you will need to be more precise. What is the formula you are using? Which cell do you type this into? What is the data in the cells referenced by this formula? What is the result of the formula? Which cell do you copy the formula to (or an example if there are many)? What is the resulting formula? What is the data in the cells referenced by this new formula? What is the result of this new formula? What do you expect the result to be? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a file with only values no formulas | New Users to Excel | |||
| Changing formulas from relative to absolute | Excel Discussion (Misc queries) | |||
| copy formulas without associated values | Excel Worksheet Functions | |||
| Copy Values in a cell (derived from formulas) | Excel Worksheet Functions | |||
| Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
Hybrid Mode
