| 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 | |||
| Copy cells to neighbor column after leaving the cell | Excel Worksheet Functions | |||
| Making all cells in a column links? | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How can i copy a group of cells in a row to a column? | Excel Discussion (Misc queries) | |||
| Rounding formula won't copy to other cells in column - why? | Excel Discussion (Misc queries) | |||
Linear Mode
