Hi,

I need a little help.

Is it possible to automatically update cells when you enter things
into cells that are not in the same place.

For example. I want to have the a cell automatically update when i
enter a value on the row. I Have a column that needs updating with the
latest value on the row but obviously the row has different value
along it. E.G B1-C1-D1 are all different values but i want D1 as this
is the latest one.

Would i have to change the formula everytime or is there a formula
that would work??

Please could you help...feel free to email me

also dont hesitate to ask if i have left a little confusion

thank you

Dale

I'm not sure what you want but you can do this sort of thing with a
worksheet_change event in the sheet module.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
Hi,

I need a little help.

Is it possible to automatically update cells when you enter things
into cells that are not in the same place.

For example. I want to have the a cell automatically update when i
enter a value on the row. I Have a column that needs updating with the
latest value on the row but obviously the row has different value
along it. E.G B1-C1-D1 are all different values but i want D1 as this
is the latest one.

Would i have to change the formula everytime or is there a formula
that would work??

Please could you help...feel free to email me

also dont hesitate to ask if i have left a little confusion

thank you

Dale