Copying & Transposing #'s

[sue]

Hi
I am using Excel 2000. I am copying a range of numbers
from one worksheet to another. I would like the new
worksheet to update itself every month when the production
#'s are added to the old worksheet. However, when I copy
the #'s to the new worksheet I must transpose the #'s. Is
there anyway to do a paste-link and transpose the #'s to
the new worksheet at the same time?

Thank You

 

[Frank Kabel]

Hi
you may explain with some more detail how you want to transpose your
data 8maybe you post some example data in plain text)

 

[Dave Peterson]

Maybe this'll work:

Insert a helper worksheet (to be deleted later)

Edit|copy your original range
Edit|paste special|paste link (on that helper worksheet)

Now Edit|replace
replace =
with
$$$$$

Edit|Copy that helper range (now just plain old text)

Go to the real location
edit|paste special|transpose

Edit|replace
replace $$$$$
with
=

(and excel will change them back to formulas (links) to the other cells.)

If your data contains $$$$$'s, then use some other unique string of characters.

 

[sue]

33,808
209
0.6%

2,292
939
41.0%
14,750
This is an example of the different types of #'s I am
transposing from the original worksheet. They are all a
result of formulas. Will that make a difference in our
answer to me. Sorry should have specified this in my
original post.

Thank You

 

[sue]

A Thousand Thank You' It works!!!

-----Original Message-----
Maybe this'll work:

Insert a helper worksheet (to be deleted later)

Edit|copy your original range
Edit|paste special|paste link (on that helper worksheet)

Now Edit|replace
replace =
with
$$$$$

Edit|Copy that helper range (now just plain old text)

Go to the real location
edit|paste special|transpose

Edit|replace
replace $$$$$
with
=

(and excel will change them back to formulas (links) to the other cells.)

If your data contains $$$$$'s, then use some other unique string of characters.



--

Dave Peterson
(e-mail address removed)
.