Hi,

I have been assigned a task to calculate overtime for about 30 employees.
The data (hours worked each day) is captured in individual spreadsheets on a sharepoint site.

I was wondering what is the best way to access these files, get the data for each employee,
and then capture summary in a top level summary excel file. The summary would include pivot
tables...

I can write code in VBA but am not familiar with accessing files on sharepoint as well as
the best way of accomplishing this task.

I will appreciate your help.

Thanks

Alpesh