Easier Way to extract data

Hi All,

The attached excel file is a logfile from a tool that usually stores it as a .dat file. At the moment I have to open the file in excel and select text to columns and then filter the data. File already filtered

Date/Time/Event/System/Data

What I am looking for is to be able to open excel and run a script to do the above automatically.

After this is done I would then like to be able to

Look at the event column and check each SECS load

for example below. I would like to store these in a separate tab with the product ID, time and recipe.

05/04/2009 00:12:29 SECS Input 2 Product ID "F325162.1/F325161.1" selected.
05/04/2009 00:12:30 SECS Input 2 Recipe "DEWET850" selected.

Once the above is done I then need the process finish time for the same lots. I would like to calculate the total time taken to process all lots

This can be filtered by Event (notice) and System (output 3)

05/04/2009 01:08:25 Notice Output 3 Finished product (F325162.1/F325161.1) at position.
05/04/2009 01:09:04 Notice Output 3 (Cleared) Finished product (F325162.1/F325161.1) at position.


Can this be done with a macro? how easy would this be?

Any help would be appreciated