| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer cell value as part of formula
Hello!,
I have to consolidate data from various excel workbooks. Each workbook is have name of employee for whom info is in worksheet. To summarise I wish to creat a workbook. Normally, I can create link ='[vaijayanti.xls]Page 1'!$B$2. What I wish to do is replace '[vaijayanti.xls]Page 1' with a cell reference $A$1 where I can type name of employee to see data. thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Refer cell value as part of formula
=INDIRECT(A1&"$B$2")
Regards, Stefi €žAbhay€ť ezt Ă*rta: Hello!, I have to consolidate data from various excel workbooks. Each workbook is have name of employee for whom info is in worksheet. To summarise I wish to creat a workbook. Normally, I can create link ='[vaijayanti.xls]Page 1'!$B$2. What I wish to do is replace '[vaijayanti.xls]Page 1' with a cell reference $A$1 where I can type name of employee to see data. thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
| Use cell contents to refer to a sheetname in a formula | Excel Worksheet Functions | |||
| how i can refer to cell in long formula go to another file | Excel Discussion (Misc queries) | |||
| Request for formula to refer some letters from Cell | Excel Worksheet Functions | |||
| How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
