getting value to change when value entered in new cell of column

[tvonbehren]

Not sure if I can do this with a formula or not

looking to change the value of a cell when using a column. Im looking to have the cell to change each time after there is a new value entered in the column but only when a value is entered in new cell of the column.

[Richard Buttrey]

Hi,

I think you'll need to upload an example of your data and what you expect to see when the relevant value has changed.

Regards

[tvonbehren]

I have a cell that i want the value to change to the newest or latest value that is entered into a column. Say that I have a value intered into columnA at cell B1 and I want that to equal to say cell F6. but then I enter a value in C1, then I am needing F6 to change to the value of C1. and so on for the whole column or until to a certain cell say F20

[Richard Buttrey]

Hi,

I think you need to upload an example workbook which contains your data, and and a note as to what resultant values you expect to see, in which cells, and why if the relationship is not immediately obvious.

Rgds

[JBeaucaire]

If what you want is the last value going down the column, this formula would do that with no VBA:

If the values are always numeric:
=LOOKUP(9.9E+307, A1:Z1)

If the values are always text:
=LOOKUP("zzzz", A1:Z1)

If the values are a mixture:
=LOOKUP(2, 1/(A1:Z1<>""), A1:Z1)

========

If what you want is the last value entered in a range of cells regardless of the order they were entered, like A1, E1, F1, then B1 ... F6 would now be showing B1... that would require a worksheet_change macro.

[tvonbehren]

Thank you for all the help really appreciate it.