I want a immediate help please, ie, i want to create a Report Sheet in excel whose properties are:
if a new expected (excel) file (the file name is expected one & also it is in a series & also it is within a folder) is created, the information of a specific cell, of each files (expected) say B5, should automatically come into a cell in another one excel file, (the Report Sheet). Is this possible in excel..?
The application of this is, while creating invoices, a report giving the amount & date of the invoice should come into another sheet (Report Sheet) for sending monthly statements. (Each Invoices are saved as seperate files)
Possible..? can anyone help...?Please...
T Mahroof