In the attached files, you will find a XLSM
If you run the macro contain with in file you will see that it Imports the other raw data files and completes a range of functions
Including: formatting, sorting, Clearing contents, renaming sheets and data headers....etc
The files will need to be in C:\Raw Data (directory) the macro i made currently runs across all worksheets.
Now with the help of another thread and the efforts on Both SinTek and Jindon and others who replied they created the folllowing macro's which summed and counted
between the hours on the dataset i provided . in that post
Here are the different macro's and approaches (BOTH worked very well)
SinTek
------------
JinDon
If at all possible can either be modified to to work across data ranges of worksheets and workbook
Attachments Xlsm and two .CSV files of raw Data ............ plus Zip file with complete dataset of CSV's
Bookmarks