read pdf or doc file line by line and then parse the data into the proper cells and rows.

I have the data to import / read in a pdf, in a doc, or in an Excel worksheet whichever is easier to use.
I need to import the data, parse it into the correct cells for that row and then repeat the import until the end of the file.
Not all the cells are in each group of data to import, so those cells will be null for that row.
Some of the data for one cell may be in up to 14 lines in the data file. I have be concatenating these data rows into one cell.
There are 48,000 lines in the file to import or I would do this manually.
I am assuming that doing this in VBA would be the most efficient method.
Thanks,
rtphilli

Okay, I've got it reading the doc file into memory I just need to know the answer to those questions. I figured out where column c comes from so I know what to do there. The lines like "CPN 963-5348-270 Rev - CAGEC 0EFD0 Rockwell Collins. - Proprietary Information Page: 12", do you want that data captured and stored?

The best way to work with logs is in the original raw data format. Do you receive these in word format? Pdf? Txt? Something else?

Column A can be used. I was using it while I was moving information manually, it is no longer needed for an import.
The page information is also not needed. I have attached a portion of the file Excel Post 2 that contains the MCID information.
Dynamic spacing is great because I would like to import other similar files with this.
I would like the import to be in a new workbook if possible.
Thanks for your time.
rtphilli

Also, Column C that does not have a header can be titled Section if you need too.

Here's the file. It's got a sheet1 that has a button to do what you wanted.
Excel Post.xlsm

Awesome, Thank you very much. I have a minor problem at this point.
I get "Can't find project or library" when I run I click the button. I have the word doc in the same directory as the excel spreadsheet.

If you go into the VBA editor and hit Tools > References, which one does it say is missing? I had to add Microsoft Word 14.0 Object Library, so that might be the one missing. Try unchecking it and adding in the version you have installed.

Under Tools, References is grayed out and not selectable.

That's good to know. Let me know if there are any problems.