Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Transpose and link at the same time?
I have a five-cell row which I would like to link to a five-cell column. This
would mean that I need to transpose and link at the same time. Anyone know how? Thanks! |
#2
|
|||
|
|||
Saved from a previous post:
You could try this: Copy|paste special|paste link (but in an out of the way location) Then select those cells edit|replace what: = with: $$$$$= (some unique string) replace all. Now those formulas are strings Copy|paste special|transpose select the range edit|replace what: $$$$$= (same string) with: = replace all And clean up that out of the way helper range Nuttysmallbar wrote: I have a five-cell row which I would like to link to a five-cell column. This would mean that I need to transpose and link at the same time. Anyone know how? Thanks! -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave! I'll try!
"Dave Peterson" wrote: Saved from a previous post: You could try this: Copy|paste special|paste link (but in an out of the way location) Then select those cells edit|replace what: = with: $$$$$= (some unique string) replace all. Now those formulas are strings Copy|paste special|transpose select the range edit|replace what: $$$$$= (same string) with: = replace all And clean up that out of the way helper range Nuttysmallbar wrote: I have a five-cell row which I would like to link to a five-cell column. This would mean that I need to transpose and link at the same time. Anyone know how? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i past link and transpose simultaneously? | Excel Discussion (Misc queries) | |||
how do I transpose and paste a link in excel | Excel Worksheet Functions | |||
how to link from column to row? | Excel Worksheet Functions | |||
Trying to transpose linked data using Paste Special | Excel Worksheet Functions |