Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a worsheet name (filename), and a range name as values?
Hi, I have a case where I get two files all the time, the files needs to be
combine, and they have different lenght of rows always, so I wonder if in one part of my formula I can refer to a value in a cell, instead of the filename itself. for example if a formula needs to read data in one file name toby, in some part of the formula the filename will be embedded, together with the sheet name, but what I want is to create a setup sheet where i put values like: Input file 1=Source1.xls Input sheet 1=end_of_day range 1=A1:Z200 So my formula picks up the source1.xls, the end_of_day and the range from this "variables", which will apply for filr 1 and 2 that need to be processed, isntead of my applying all the formulas to this files again. Is that possible? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a worsheet name (filename), and a range name as values?
Just using INDIRECT
"RobertoB" wrote: Hi, I have a case where I get two files all the time, the files needs to be combine, and they have different lenght of rows always, so I wonder if in one part of my formula I can refer to a value in a cell, instead of the filename itself. for example if a formula needs to read data in one file name toby, in some part of the formula the filename will be embedded, together with the sheet name, but what I want is to create a setup sheet where i put values like: Input file 1=Source1.xls Input sheet 1=end_of_day range 1=A1:Z200 So my formula picks up the source1.xls, the end_of_day and the range from this "variables", which will apply for filr 1 and 2 that need to be processed, isntead of my applying all the formulas to this files again. Is that possible? Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use a worsheet name (filename), and a range name as values?
Forgive my previous typo.
Try using INDIRECT. "RobertoB" wrote: Hi, I have a case where I get two files all the time, the files needs to be combine, and they have different lenght of rows always, so I wonder if in one part of my formula I can refer to a value in a cell, instead of the filename itself. for example if a formula needs to read data in one file name toby, in some part of the formula the filename will be embedded, together with the sheet name, but what I want is to create a setup sheet where i put values like: Input file 1=Source1.xls Input sheet 1=end_of_day range 1=A1:Z200 So my formula picks up the source1.xls, the end_of_day and the range from this "variables", which will apply for filr 1 and 2 that need to be processed, isntead of my applying all the formulas to this files again. Is that possible? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting values from a filename as a date in a cell | Excel Discussion (Misc queries) | |||
worsheet | Excel Discussion (Misc queries) | |||
Using Range().Formula with a Filename & Path | Excel Discussion (Misc queries) | |||
set filename to <filename-date on open | Excel Worksheet Functions | |||
Using TODAY() to generate a filename from where values are VLOOKUPed | Links and Linking in Excel |