Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell remember a number?...
Hi all
If I generate a number in cell A1 for example, can cell B1 receive the value and remember it when I re-generate a new number in cell A1, a new cell B2 should display the new number from A1, and B1 should still show the first value generated from A1 Thanks for any help on this one Hope it makes sense... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell remember a number?...
On Jun 23, 11:59*am, Markv wrote:
Hi all If I generate a number in cell A1 for example, can cell B1 receive the value and remember it when I re-generate a new number in cell A1, a new cell B2 should display the new number from A1, and B1 should still show the first value generated from A1 Thanks for any help on this one Hope it makes sense... In case u wish the values generated by some formula in A1 to be displayed in different cells as and when the inputs to A1 changes, u can actually record a paste value code in the next blank cell in column B and you can run this code on change in A1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell remember a number?...
Hi thanks for the input, however I am only learning just how to work with
formulas in excell, so I would have no idea, how to set this up. Can you help "Nayab"? thanks mate "Nayab" wrote: On Jun 23, 11:59 am, Markv wrote: Hi all If I generate a number in cell A1 for example, can cell B1 receive the value and remember it when I re-generate a new number in cell A1, a new cell B2 should display the new number from A1, and B1 should still show the first value generated from A1 Thanks for any help on this one Hope it makes sense... In case u wish the values generated by some formula in A1 to be displayed in different cells as and when the inputs to A1 changes, u can actually record a paste value code in the next blank cell in column B and you can run this code on change in A1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell remember a number?...
I have a similar requirement. A formula in a column of cells uses a number
from an input cell. When I change the input value after already completing some calculations in the column, all the previous values in the column change to the new inputted value. I understand the "Special Paste Value" approach but how do I set up the cell to do that automatically. This seems like other problems I have in attempting to link a macro with a cell (I can link it to a "hot button" etc but not to a cell) .... any advice? thanks for any input. ARGT "Nayab" wrote: On Jun 23, 11:59 am, Markv wrote: Hi all If I generate a number in cell A1 for example, can cell B1 receive the value and remember it when I re-generate a new number in cell A1, a new cell B2 should display the new number from A1, and B1 should still show the first value generated from A1 Thanks for any help on this one Hope it makes sense... In case u wish the values generated by some formula in A1 to be displayed in different cells as and when the inputs to A1 changes, u can actually record a paste value code in the next blank cell in column B and you can run this code on change in A1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell remember a number?...
Here is an example that keeps a running record of the computations in cell
A1. It is a worksheet event macro. As the value in A1 changes, each new value is recorded in column B: Private Sub Worksheet_Calculate() Set a1 = Range("A1") v = a1.Value If IsEmpty(Range("B1").Value) Then Range("B1").Value = a1.Value Exit Sub End If n = Cells(Rows.Count, "B").End(xlUp).Row If v = Cells(n, "B").Value Then Exit Sub Cells(n + 1, "B").Value = v End Sub The macro should be installed in the worksheet code area, not a standard module. -- Gary''s Student - gsnu200793 "Markv" wrote: Hi all If I generate a number in cell A1 for example, can cell B1 receive the value and remember it when I re-generate a new number in cell A1, a new cell B2 should display the new number from A1, and B1 should still show the first value generated from A1 Thanks for any help on this one Hope it makes sense... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can someone please help me to remember | New Users to Excel | |||
Why and How Does Excel Remember The Last Cell? | Excel Worksheet Functions | |||
I used to be able to do this, I can't remember how | Excel Discussion (Misc queries) | |||
Remember and add | New Users to Excel | |||
How do I get a cell to remember the last entry and add to it? | Excel Discussion (Misc queries) |