Hi,

Say I have objects placed in Col c, d, e, f, g, h, i, j in row 8 and I need
to assign macro for each object such that

when I click on object which is in d8, then it should copy the value of d7
and paste in may be a1

when I click on object which is in e8, then it should copy the value of e7
and paste in may be a1 again.. and so on..

can anyone help me with this pls..

Thanks..