| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ecel:create a file name from data in worksheet
I wish to extract data from several workbooks that are created every day.
The daily workbooks have a common eliment in their file names Eg. On the 1st of june the file names would be :- ABC 010607 def 010607 on the 2nd of june the file names would be:- ABC 020607 def 020607 I wish to create ao spread sheet that I cancreate the file name:- ABC+"010607" def+"010607" The next day I would just have to update the +"******" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
| create 50 copies of a worksheet in the same file | Excel Worksheet Functions | |||
| How do I create a new worksheet for a subset of data | Excel Discussion (Misc queries) | |||
| how do i create and save a new file or worksheet autmatically ever | Excel Discussion (Misc queries) | |||
Threaded Mode
