I would like to link one long row of cells from one worksheet to one long
column of cells on another. I have to do this in many cases, so paste-linking
one cell at a time is not feasible. How can I transpose a paste-link
operation?
I would like to link one long row of cells from one worksheet to one long
column of cells on another. I have to do this in many cases, so paste-linking
one cell at a time is not feasible. How can I transpose a paste-link
operation?
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
rpcar wrote:
>
> I would like to link one long row of cells from one worksheet to one long
> column of cells on another. I have to do this in many cases, so paste-linking
> one cell at a time is not feasible. How can I transpose a paste-link
> operation?
--
Dave Peterson
Good solution! Thank you, Dave.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks