So I've been tasked to combine 92 unusable workbooks into a single useful workbook. The attached workbook is an example of the 92 headaches I have. I'm not much of an excel guru, more of a script kitty (kid-die is censored? lol), but I know that if I hand-jam all the data it will take me forever.
If you're looking at my attachment (attachment data has been sanitized to protect the actual data, sorry) you will see six "blocks" of data. What I need to do is pull the data from all 92 workbooks and put it into one workbook presented like columns N-T in the attachment. The source workbooks are always three blocks across, but don't always contain the same number of blocks. They are located in the same columns, but don't always occupy the same rows because each block doesn't always contain the same amount of data. The blocks always have the same heading; listing the worker, start location, info1, and info2. What changes is the number of white lines below each of the yellow "Time, job @ location" lines. The comma and @ sign always appear in the yellow line. The date column is derived from the file name of each workbook. The dates in the file name appear in alphabetic format ie June 1 = GR, June 2 = GS, June 3 = GT, June 10 = HA, and Aug 31 = KE... if that makes any sense... the file names all start with (X) followed directly by there alphabetic date AKA GR. So a workbook's file name might appear as (X) GR.xls
Hopefully I've described the problem adequately. I don't even know where to start with this... please help.
Bookmarks