Summarize data

[Chris Waller]

I am trying to Consolidate data from about 9 or 10 different workbooks. The data is in the same format (columns), however the amount of data (length of each spreadsheet) is different and in no particular order.

I am trying to summarize the data by the name of the employee and the date. I am trying to calculate if we are being overcharged on any particular date. I have just been playing with the consolidate function, but was unable to achieve what I was trying to do. Does anyone know an easy way of bringing all this data together to summarize by name of employee and the date and I want to calculate the number of hours worked on any particular day by said person. All this data is held in different columns on all the spreadsheets? TIA

 

[Aladin Akyurek]

Different workbooks or different sheets in the same workbook?

 

[Chris Waller]

Aladin,

They are different Workbooks.

 

[Aladin Akyurek]

Aladin,

They are different Workbooks.

I think the VBA route would be advisable here. I hope someone into VBA would like to consider the question/the suggestion.