| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to transpose data (Row to column) without losing the cell link
If I transpose data (horizontal row to vertical column)from one sheet to
another with the "copy" and "Paste Special" command using "transpose", the programme only gives the values. I need to keep the link to the original sheet to ensure that if any data is changed in the original sheet (row) that it changes in the column on the new sheet. I have tried the "Transpose" @-function unsucesfully!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose Data with fixed first column | Excel Discussion (Misc queries) | |||
| link data in a column to one cell | Excel Discussion (Misc queries) | |||
| Transpose Data from a column to several rows | Excel Worksheet Functions | |||
| Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
| I have a column of data and I'd like to transpose it to go across. | Excel Discussion (Misc queries) | |||
Threaded Mode
