Is there a formula that can automatically copy values from a cell reference that you change its value everytime? If there is, pls.. pls.. pls.. pls..
2007-06-26 16:21:13 · 2 answers · asked by FuzZ 2 in Computers & Internet ➔ Software
You need to force the spreadsheet to recalculate which you can do by pressing the F9 button. Then it will take the new value and enter it into the calculations.
If you right click on a tool bar you can select the bottom option in the column: Customize. This lets you add buttons to the tool bars. You can find this button under the tools option: Calculate Full. You could also write a Macro to do the same thing. Or you could go to the Tools Menu, select the choice options and find it under the calculation tab.
2007-06-26 16:30:59 · answer #1 · answered by Dan S 7 · 0⤊ 0⤋
I am pretty sure that you can simply type an example like:
=F3 (that would take the value of any info in Column F and row 3 and place it in the cell you type this in.)
2007-06-26 23:25:11 · answer #2 · answered by ? 4 · 0⤊ 0⤋