How to copy a row with transposing to a column retaining links to input cells?

Hello!
How to copy a row with transposing to a column retaining links to input
cells? Excel transposes with a links change or only values.
Best regards,
Dima
+7 9163876746

Maybe you can change the formulas to strings, copy|paste special and change the
strings back to formulas.

I do this:

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

Do the copy and paste special|transpose.

Then change the $$$$$= back to = in both the copied range and pasted range.

Dmitry wrote:
>
> Hello!
> How to copy a row with transposing to a column retaining links to input
> cells? Excel transposes with a links change or only values.
> Best regards,
> Dima
> +7 9163876746

--

Dave Peterson

Thanks Dave Peterson for your instruction!
"Dave Peterson" <petersod@verizonXSPAM.net> ???????/???????? ? ????????
?????????: news:44BCCE37.C4BF9831@verizonXSPAM.net...
> Maybe you can change the formulas to strings, copy|paste special and
change the
> strings back to formulas.
>
> I do this:
>
> Select the range to copy
> edit|replace
> what: = (equal sign)
> with: $$$$$=
> replace all
>
> Do the copy and paste special|transpose.
>
> Then change the $$$$$= back to = in both the copied range and pasted
range.
>
> Dmitry wrote:
> >
> > Hello!
> > How to copy a row with transposing to a column retaining links to input
> > cells? Excel transposes with a links change or only values.
> > Best regards,
> > Dima
> > +7 9163876746
>
> --
>
> Dave Peterson