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 |
How to copy a row with transposing to a column retaining links toinput cells?
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 |
How to copy a row with transposing to a column retaining links to input cells?
Thanks Dave Peterson for your instruction!
"Dave Peterson" ???????/???????? ? ???????? ?????????: ... 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 |
All times are GMT +1. The time now is 03:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com