V
VILLABILLA
I have a set of data that has to be pasted on another sheet and I want
to link each cell with the cells I copied the data from. This is not a
problem because of the 'paste link' function when I use 'paste
special'. But my problem is that I also want to 'transpose' the data
while copying. When I click the transpose function in the paste special
window, the 'paste link' function no longer can be used.
I just can't find a work around for this issue and maybe some one else
knows can help me with this.
p.s. does someone know a handy FREE tutorial on the i-net on how to
work with a pivot table?
Thanks in advance!
to link each cell with the cells I copied the data from. This is not a
problem because of the 'paste link' function when I use 'paste
special'. But my problem is that I also want to 'transpose' the data
while copying. When I click the transpose function in the paste special
window, the 'paste link' function no longer can be used.
I just can't find a work around for this issue and maybe some one else
knows can help me with this.
p.s. does someone know a handy FREE tutorial on the i-net on how to
work with a pivot table?
Thanks in advance!