| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose data and retain links to original data
Hi
I know this topic has already been raised but I am not sure I understood any of the answers. I am a novice where functions like OFFSET and INDEX are concerned. What I would like to do is transpose horizontal data from Sheet1! row $C$4:$CB$4 and place it in Sheet2! column $G$10:$G$61 while retaining the links to the original data in Sheet1!- how do I do that? What is the formula which will produce this result. Regards Neil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fetching data and deleting original data | New Users to Excel | |||
| Switch to change data fields to 0's, then back to original data? | Excel Discussion (Misc queries) | |||
| Change number of decimals but retain original style | Excel Discussion (Misc queries) | |||
| Data depiction/transpose and retain formulas | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Threaded Mode
