Dan,

You could check the file date, if the only reason a file is saved is that
data has been added to it. If so, a macro would find them easily. Otherwise,
you would need a different approach.

Let us know,

Bernie
MS Excel MVP

"Dan Thompson" wrote in message
...
Hi,
I have about 1000 excel workbooks I work with on a regular basis each one
of
them has data and 1 chart. All of the Workbooks and charts get updated
each
month. however some of them do not do to a lack of available data. I am
wondering if there is a macro that can check each workbook to see if new
data
has been added since the last time the macro was run and generate a master
list in a separate workbook of all the work books that have new data since
the last time the macro was run and a list of all the workbooks that have
not
had new data since the last time the macro was run.

Can anyone help either with a macro or point me to a site that may already
have some kind of macro like this ?

Thanks,
Dan Thompson