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
Bookmarks