searching in multilple worksheets

[adhhealth]

Hi,

There are many (100 or more) excel worksheets in a folder in the same format- ex: scheduled-date actual-date description and so on.. each file will have different values under these fields.

From all these excel files i have to pickup the row where the 1. datediff(scheduled date ,actual date) >2 or
2. datediff(scheduled date ,today's date)>2
and create a new "delays" summary excel file.

is it possible to do this??
or actually we are planning to completely revamp this system,to accomplish this functionality from entering data in a way that these summary reports can be generated(using office 2000), can someone suggest any other
better way that is possible??

 

[SkipVought]

Hi,

You have 100 to more Excel Workbooks in a folder.

What you want to do will require VBA coding.

Please post this request in forum707, VBA Visual Basic for Applications (Microsoft)


Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}