|
how to link horizontal data to vertical cells in a new sheet
1 Attachment(s)
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. |
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| +-------------------------------------------------------------------+ |
| All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com