| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable File Name
Hello,
What formula can I use to make the file name variable? Ex: If my formula reads as follows: SUMIFS([200902_UPS.xls]UPS_CSV_EXPORT!$G:$G,[200902_UPS.xls]UPS_CSV_EXPORT!$F:$F,A117) For the month of February, the file name is 200902_UPS.xls. I want to make the 200902 portion variable by referencing to a cell which provides the month number so that in March, the name would be 200903. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling a value from another file using a variable in the file nam | Excel Worksheet Functions | |||
| calling a value from another file using a variable in the file nam | Excel Discussion (Misc queries) | |||
| Referring to a variable file name | Excel Discussion (Misc queries) | |||
| Variable File Name | Excel Worksheet Functions | |||
| Inport from a variable file name | Excel Discussion (Misc queries) | |||
Threaded Mode
