Hello
I have been using MS excel for the last few years. While many of the functions are known to me, I do not know how to transpose horizontal data to vertical data with paste link. If data in a horizontal form is transposed with paste link, it works superb. Whereas, the horizontal data with paste link is not converted into vertical data with link to the source of data. If anybody can help, please do so

devadhasan
bangalore