To be more exact,
For example,

I have number 25 at (A,26) i want to duplicate it to (B,5)
and when next time round, (A,26) changes to another number like 39. I want to duplicate it to another place like (B,6)

How should i go about using VB to manipulate MS Excel. All the numbers or data comes are from another program so its more like when data comes, VB only assist to copy the data to another place for reference. That's all. No fanciful stuff involved.

Does that help to clear some of your doubts.