Auto Data paste in new cell

[GaurangThakar]

Hi ,
I need a help , I've one sheet name "PDA" . I'm copying cell no . C6 to I6 then I paste that value in cell no C7to I7. Then again I'm Copying cell no C6 to I6 (when gets refresh and new data arrived) and then I'm paste data in cell no C8 TO I7. Then again I'm copying cell no C6 TO I6 and paste that value in cell no C9 to I9 and so on... , Is it possible to paste data automatically in new cell when cell no C6 to I6 get auto refreshed


Thank you.

 

[Yongle]

we need to determine why worksheet calculate is triggered 3 times

how are the values in the sheet being refreshed?