| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
workbook in formula
Is there a way to have the name of a workbook in a formula from a column in
another column? For example, the workbook's name is in A1 like test.xls, the formula will be in column b referencing test.xls as follows: ='[" & A1 & "]tabname'!$B$8 Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
workbook in formula
Use the INDIRECT() function. Look in Help for details.
-- Kind regards, Niek Otten Microsoft MVP - Excel "ellen" wrote in message ... | Is there a way to have the name of a workbook in a formula from a column in | another column? For example, the workbook's name is in A1 like test.xls, the | formula will be in column b referencing test.xls as follows: | | ='[" & A1 & "]tabname'!$B$8 | | Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
workbook in formula
if text.xls is open, use
=indirect('[" & A1 & "]tabname'!$B$8) "ellen" wrote: Is there a way to have the name of a workbook in a formula from a column in another column? For example, the workbook's name is in A1 like test.xls, the formula will be in column b referencing test.xls as follows: ='[" & A1 & "]tabname'!$B$8 Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
workbook in formula
I copied your formula exactly but it comes back with a #REF error. Any
further help would be appreciated. Thanks! "Duke Carey" wrote: if text.xls is open, use =indirect('[" & A1 & "]tabname'!$B$8) "ellen" wrote: Is there a way to have the name of a workbook in a formula from a column in another column? For example, the workbook's name is in A1 like test.xls, the formula will be in column b referencing test.xls as follows: ='[" & A1 & "]tabname'!$B$8 Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
workbook in formula
tabname stands for the name of sheet, replace it with the name of the sheet
in question -- Regards, Peo Sjoblom "ellen" wrote in message ... I copied your formula exactly but it comes back with a #REF error. Any further help would be appreciated. Thanks! "Duke Carey" wrote: if text.xls is open, use =indirect('[" & A1 & "]tabname'!$B$8) "ellen" wrote: Is there a way to have the name of a workbook in a formula from a column in another column? For example, the workbook's name is in A1 like test.xls, the formula will be in column b referencing test.xls as follows: ='[" & A1 & "]tabname'!$B$8 Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with Excel formula in a Workbook | Excel Worksheet Functions | |||
| Displaying formula from one workbook in another | Excel Worksheet Functions | |||
| Link A Cell In O ne Workbook To A Formula In Another Workbook | Excel Worksheet Functions | |||
| how to copy formula from one workbook to another | Excel Discussion (Misc queries) | |||
| Copy Formula to Different Workbook | Excel Worksheet Functions | |||
Hybrid Mode
