W
Wes_A
Good day all. Excel 2007. XP Pro.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be 10 etc. The files all have the same name excepting for the first 8
characters which identify the cost centre, year and month. e.g.
A2010JANSTANDARDFILENAME
Any suggestions appreciated.
PS Has anyone ever considered compiling an indexed resource with the
answaers to all these questions? Maybe this would be a marketable product.
Is there a way to have all available excel files in a particular folder
listed (updated in real time) in an excel spreadsheet where the user can
click on one or more of them to open those files or at least retrieve
specific data from them?
I have a situation where files representing cost centres and each month of
the year need to present data into a worksheet used for reporting purposes.
So potentially 5 x 12 = 60 files. But these are only created as the months
pass. so at the end of month1 there would only be the 5 files, month 2 there
would be 10 etc. The files all have the same name excepting for the first 8
characters which identify the cost centre, year and month. e.g.
A2010JANSTANDARDFILENAME
Any suggestions appreciated.
PS Has anyone ever considered compiling an indexed resource with the
answaers to all these questions? Maybe this would be a marketable product.