Parse Data file to copy values into a Column format

Hi-
I have a hurdle I am trying to overcome I think VB will help me achieve my goal, I don't have any experience with VB, but I do have experience with formulas and data manipulation using Excel. However, the format of the data file has left me in a quandary. I am trying to parse the data in an output/data file and place it into a column format so I can do look-ups and summaries. The file is a grouping of time records. I need to associate each record with an individual. This is my problem, the individual's name is a header for the group of times. The group of times are in a list below the header. The number of time records within in a group will vary so I can't always go to the same cell to grab an individuals name. The number of individuals will also vary from each file.

The data I am hoping to work with would look like this;

Column 1 Column 2 Column3 Column 4
Name time date Charge To Time value
Name time date Charge To Time value

I have attached 2 data files, I have also attached a final output file, which has two sheets. The first sheet is what the parsing should do to the 2 data files. The second sheet of the output file is what I will be doing to summarize the data from the first sheet. Let me know if I still haven't done a good job in explaining what I am trying to accomplish.

Example - data file1.xls
Example - data file2.xls
final output.xlsx

Researcher007,

This code will prompt you to select files that you want to create the parsing output from. It will then use the contents of those files to create the parsing output as specified by your 'final parsing output from data' sheet in your final output.xlsx example file.

Please Login or Register  to view this content.