paste with transpose function AND paste links at same time

[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!

 

[Dave Peterson]

How about doing the paste in few steps?

1. Copy your range
2. Find an unused area and paste|special|Paste link
3. With the pasted area selected,
change = to $$$$$=
(via Edit|Replace)
Now, all your formulas are values
4. Copy this new range
Select the real home and edit|Paste Special|Transpose
5. Finally,
change $$$$$= back to =
And your formulas will reappear.


Here are some links for pivottable info:

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

 

[Bruce Sinclair]

How about doing the paste in few steps?

1. Copy your range
2. Find an unused area and paste|special|Paste link
3. With the pasted area selected,
change = to $$$$$=
(via Edit|Replace)
Now, all your formulas are values
4. Copy this new range
Select the real home and edit|Paste Special|Transpose
5. Finally,
change $$$$$= back to =
And your formulas will reappear.


Here are some links for pivottable info:

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx

I have wanted to do this once before and (IIRC) the answer was to
'array enter' the transpose function. It was not (again IIRC) and
elegant solution
Not sure exactly what I did now ... but that might give you a start in
places to look/things to try ?

Bruce

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!

-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone´s fault.
If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
I´ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We´re always one of Us. It´s Them that do
the bad things. <=> Terry Pratchett. Jingo.