| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
linking whole rows of cells
Hi folks, How can I easily link all of the cells in a row to all of the cells in a row in another workbook without having to individually create each link? TIA! -- fxcel ------------------------------------------------------------------------ fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864 View this thread: http://www.excelforum.com/showthread...hreadid=384069 |
|
#2
|
|||
|
|||
|
In A2 enter
=A1 and copy across till the number of columns is reached. Mangesh "fxcel" wrote in message ... Hi folks, How can I easily link all of the cells in a row to all of the cells in a row in another workbook without having to individually create each link? TIA! -- fxcel ------------------------------------------------------------------------ fxcel's Profile: http://www.excelforum.com/member.php...o&userid=24864 View this thread: http://www.excelforum.com/showthread...hreadid=384069 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Pictures in Cells | Excel Worksheet Functions | |||
| I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
| How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| I Need to divide all cells in rows 2 and 3 by 100 | Excel Discussion (Misc queries) | |||
Linear Mode
