| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Referencing rows to columns
I have one spreadsheet where the data is shown weekly by row, I want to
summarise this into a spreadsheet where the data is shown weekly by column. In otherwords I want to reference cells A7, A8, A9 etc on the first sheet to A7,B7,C7 etc on the second sheet. The first sheet is linked to other files so I dont want to change it. Can anyone help please? Many thanks -- GLS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing columns to rows | Excel Worksheet Functions | |||
| Each rows last cell text value could be in any columns. | Excel Worksheet Functions | |||
| Referencing columns as rows | Excel Discussion (Misc queries) | |||
| Referencing a range of columns and rows with the IF function | Excel Worksheet Functions | |||
| every nth cell by columns not rows.... | Excel Worksheet Functions | |||
Threaded Mode
