Copy data from a linked cell

[abhilash88]

Hi everyone,

I am new to this forum, I need HELP!!

I have linked an excel cell (A1) to an external source, when ever the value from the source changes the cell will reflect the same value(used Paste Special>Link). Now I need a code which can append all the values of the cell in a different column.

I would be very grateful if anyone could help on this.