I have an excel file that serves as a summary of resource utilization from
month to month. The resource information files are created automatically
each day and each have a seperate file. I would like to creatte a Macro that
will open each days resource file, get the information I need and update the
summary utilization for each month, and then delete the file and open the
next. Can you help me out? Thanks.

hi
try using "Cosolidation"
an in-built xl function
i beleive all data is in xlsheets
--
hemu


"joshroberts" wrote:

I have an excel file that serves as a summary of resource utilization from
month to month. The resource information files are created automatically
each day and each have a seperate file. I would like to creatte a Macro that
will open each days resource file, get the information I need and update the
summary utilization for each month, and then delete the file and open the
next. Can you help me out? Thanks.