| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to link horizontal data to vertical cells in a new sheet
please help.
how do i link horizontal data in sheet: LAYOUT ... row starting from C2 right across. to vertical cells in a new sheet: SLOTS coloured red but linking the two cells. which function do i use. Last edited by sinoxolo : April 13th 12 at 02:14 PM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to link horizontal data to vertical cells in a new sheet
hi,
on sheet: SLOTS range B2 =INDIRECT("LAYOUT!"&ADDRESS(2,ROW()+1)) copy down -- isabelle Le 2012-04-13 09:10, sinoxolo a écrit : please help. how do i link horizontal data in sheet: LAYOUT ... row starting from C2 right across. to vertical cells in a new sheet: SLOTS coloured red but linking the two cells. which function do i use. +-------------------------------------------------------------------+ |Filename: Capture.JPG | |Download: http://www.excelbanter.com/attachment.php?attachmentid=325| +-------------------------------------------------------------------+ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| copying formula for horizontal data to vertical in different sheet | Excel Worksheet Functions | |||
| PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
| How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
| comparing vertical list on one sheet to horizontal on another | Excel Programming | |||
Linear Mode
