software

I have worksheet #2 containing a table where all cells, including row and
column headings, contain links to values in worksheet #1 in the workbook. I
want to quot;transposequot; the table in #2 (including row and column headings) into
a table in worksheet #3, so that the rows in #2 become columns on #3 and the
columns in #2 become rows in #3, while maintaining the links to values in #1.
How do I do this.
I need a command functionally equivalent to
copy/paste special values/transpose/link
but in paste special values I can choose either transpose or link, but not
both.
Bill


2 Steps:

1. On worksheet #3 highlight the transpose range, type:
=transpose(range2) and press cntrlamp;shift Enter.

range2= the range of the table on worksheet #2 to be transposed.

2. Put your feet up on the table and smile--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531894One way:

Select the range to copy
Edit|Replace
what: = (equal sign)
with: $$$$$
replace all

Now your formulas are all text.

With that range still selected
edit|copy
then select the new location
edit|paste special|transpose

Now select each range
edit|replace
what: $$$$$
with: =
replace all

And you've converted the text back to formulas.

(Don't forget to do both the original range and the pasted range.)

Bill wrote:
gt;
gt; I have worksheet #2 containing a table where all cells, including row and
gt; column headings, contain links to values in worksheet #1 in the workbook. I
gt; want to quot;transposequot; the table in #2 (including row and column headings) into
gt; a table in worksheet #3, so that the rows in #2 become columns on #3 and the
gt; columns in #2 become rows in #3, while maintaining the links to values in #1.
gt; How do I do this.
gt; I need a command functionally equivalent to
gt; copy/paste special values/transpose/link
gt; but in paste special values I can choose either transpose or link, but not
gt; both.
gt; Bill

--

Dave Peterson


Very nice Dave--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531894John James - thanks for the solution - knew it should be easy but could not
figure it out on my own.
--
Billquot;John Jamesquot; wrote:

gt;
gt; 2 Steps:
gt;
gt; 1. On worksheet #3 highlight the transpose range, type:
gt; =transpose(range2) and press cntrlamp;shift Enter.
gt;
gt; range2= the range of the table on worksheet #2 to be transposed.
gt;
gt; 2. Put your feet up on the table and smile
gt;
gt;
gt; --
gt; John James
gt; ------------------------------------------------------------------------
gt; John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
gt; View this thread: www.excelforum.com/showthread...hreadid=531894
gt;
gt;

Dave

Thanks for your suggestion -- this actually solved an additinal delima for
me at the same time.
--
Billquot;Dave Petersonquot; wrote:

gt; One way:
gt;
gt; Select the range to copy
gt; Edit|Replace
gt; what: = (equal sign)
gt; with: $$$$$
gt; replace all
gt;
gt; Now your formulas are all text.
gt;
gt; With that range still selected
gt; edit|copy
gt; then select the new location
gt; edit|paste special|transpose
gt;
gt; Now select each range
gt; edit|replace
gt; what: $$$$$
gt; with: =
gt; replace all
gt;
gt; And you've converted the text back to formulas.
gt;
gt; (Don't forget to do both the original range and the pasted range.)
gt;
gt; Bill wrote:
gt; gt;
gt; gt; I have worksheet #2 containing a table where all cells, including row and
gt; gt; column headings, contain links to values in worksheet #1 in the workbook. I
gt; gt; want to quot;transposequot; the table in #2 (including row and column headings) into
gt; gt; a table in worksheet #3, so that the rows in #2 become columns on #3 and the
gt; gt; columns in #2 become rows in #3, while maintaining the links to values in #1.
gt; gt; How do I do this.
gt; gt; I need a command functionally equivalent to
gt; gt; copy/paste special values/transpose/link
gt; gt; but in paste special values I can choose either transpose or link, but not
gt; gt; both.
gt; gt; Bill
gt;
gt; --
gt;
gt; Dave Peterson
gt;


Bill,

Your feedback is appreciated.

Cheers,--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531894