| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting and retaining an input variable | Excel Discussion (Misc queries) | |||
| How to copy a row with transposing to a column retaining links to input cells? | Excel Worksheet Functions | |||
| transposing links | Excel Worksheet Functions | |||
| Retaining the default in an input box - again | Excel Programming | |||
| Retaining a default in an input box | Excel Programming | |||
Linear Mode
