| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting values from a filename as a date in a cell
Hi I have several excel files which automatically save as a date. I would
like to add a function to get data from a file defined in a cell. I have tried ="[("&A1&").xls]"&"Pay_Details'!$C$6" but it displays #REF! not sure if this is becaus of the date format or some other problem. eg. saved files "23-Sep-07", "30-Sep-07" Main spreadsheet A1= 23-Sep-07 B1- Datat from "23-Sep-07" file A2= 30-Sep-07 B2- Datat from "23-Sep-07" file Any help would be greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding date for filename | Excel Discussion (Misc queries) | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| set filename to <filename-date on open | Excel Worksheet Functions | |||
| How to automate footers (filename/date) for all new spreadsheets? | Excel Worksheet Functions | |||
| Using TODAY() to generate a filename from where values are VLOOKUPed | Links and Linking in Excel | |||
Threaded Mode
