Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow user-entered file reference
I've got a problem which the standard Excel package (97/2000/XP)
doesn't seem to be able to handle. Just a little background w/o the specifics... Daily, I am generating statistics on my server with each reading saved as a separate text file. Each of these text files is then converted to individual Excel workbooks. Workbook names follow the convention stat.YYYYMMDDhhmm.xls. Most of the work is done on a MASTER.xls which pulls in and manipulates data from the individual "stat.YYYYMMDDhhmm.xls" files. Each column kind of represent the stats for each day, with each row representing the different parameters. Here's the question... In the MASTER.xls, can I have a cell (in each column) where I enter the name of the file ("stat.YYYYMMDDhhmm.xls") and have all the cells in that column use what is entered as part of their reference to the values in the individual "stat.YYYYMMDDhhmm.xls"? TIA!! |
#2
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Allow user-entered file reference
see one guess at your non-crosspost in .excel.
david_news2000 wrote: I've got a problem which the standard Excel package (97/2000/XP) doesn't seem to be able to handle. Just a little background w/o the specifics... Daily, I am generating statistics on my server with each reading saved as a separate text file. Each of these text files is then converted to individual Excel workbooks. Workbook names follow the convention stat.YYYYMMDDhhmm.xls. Most of the work is done on a MASTER.xls which pulls in and manipulates data from the individual "stat.YYYYMMDDhhmm.xls" files. Each column kind of represent the stats for each day, with each row representing the different parameters. Here's the question... In the MASTER.xls, can I have a cell (in each column) where I enter the name of the file ("stat.YYYYMMDDhhmm.xls") and have all the cells in that column use what is entered as part of their reference to the values in the individual "stat.YYYYMMDDhhmm.xls"? TIA!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting worksheets containing both imported data and user entered | Excel Discussion (Misc queries) | |||
How to tell if cell contains a FORMULA or user-entered number? | Excel Worksheet Functions | |||
incrementing a date that the user has entered? | Excel Worksheet Functions | |||
I need a chart reference if certain criteria is entered... | Excel Discussion (Misc queries) | |||
Reference last entered value in a column | Excel Programming |