| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to link a cell from other spreadsheet?
Does anyone know how to code following condition for linking?
There are 2 spreadsheets TTT and PPP: I would like to link a cell A1 under report sheet for TTT spreadsheet from a cell A1 under 6183 sheet for PPP spreadsheet, but the code of 6183 is given in a cell B1 under report sheet for TTT spreadsheet. Under report sheet for TTT spreadsheet, I would like to use indirect function to join 6183 from B1 under report sheet for TTT spreadsheet in order to form the link for A1. Does anyone know how to code it? Thank you in advance Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to link a cell from other spreadsheet?
This is a formula that links to cell A1 located on a sheet withing the same
workbook. =Sheet2!A1 This formula links to an external workbook named DataSource , to sheet 1 in that file and Cell A2 on sheet 1 =[DataSource]Sheet1!$A$2 -- Kevin Backmann "Eric" wrote: Does anyone know how to code following condition for linking? There are 2 spreadsheets TTT and PPP: I would like to link a cell A1 under report sheet for TTT spreadsheet from a cell A1 under 6183 sheet for PPP spreadsheet, but the code of 6183 is given in a cell B1 under report sheet for TTT spreadsheet. Under report sheet for TTT spreadsheet, I would like to use indirect function to join 6183 from B1 under report sheet for TTT spreadsheet in order to form the link for A1. Does anyone know how to code it? Thank you in advance Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to link a cell from other spreadsheet?
Thank Kevin Backmann for your reply
='[DataSource.xls]6227.HK'!$C$2, which work in cell A1, but I would like to retrieve the value 6227 from cell B1 for this statement instead of manually input the value 6227 into the string. Do you have any suggestion? Thank you for any suggestion Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Excel should let me link one cell to another. | Excel Worksheet Functions | |||
| AUTOMATIC way to copy the value of a cell in one spreadsheet | Excel Worksheet Functions | |||
| How to link cell for value in another cell of pivot table? | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Linear Mode
