I have a log that is written every time a transaction happens in the system.
I have just moved into a new role and am being asked to analyse these logs often for issues with counts.
each of the logs has a two columns
The log is captured in a worksheet which takes on the day as its name that is
Day07 for the seventh day of the month
Day08 for the eighth and so on
The first column is always a data column
The second column is always a string of data
There are only two columns in the source data.
The following is an example of the source data
7/07/2015 14:42:47 : B19 1 Rod(s) drawn/pushed successfully on system
I would like to be able to search column B for the following
I would then like to perform the follow per message
When B19 is detected I would like to copy that cell to a new worksheet called Data in the following format
|7/07/2015| |14:42:47| |:| |B19| |1| |Rod(s) drawn/pushed successfully on system|
Date should go to column A for all messages
Time should go to column B for all messages
The colon should go to column C for all messages
The message ID should go to column D for all messages
The digit (1) should got to column E
All other data should go to Column F
Each message should be saved to a new row in the data sheet.
I had intended on doing a loop in vba to iterate through the rows but am having trouble with the search syntax and copy / paste functions.