D
Dan Thompson
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
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