Then .. perhaps you could elaborate on your intent in ..
Then I want to change one value in that row (in column D).

Do an arithmetic calc on the extracted value in col D ?
What is this change you want to make in col D?
What exactly is in col D? etc
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"bob" wrote in message
...
I left out one important point--i want to perform all of the steps I cited
automatically without any manual intervention. I also do not want to paste
values, I want a regular paste operation.