I have a brilliant macro provided by byundt to search through the message column (E) in one worksheet and extract data based on the headings in another worksheet. The data is then copied into the worksheet under the correct headings.
I have run into a problem with using this macro on another worksheet. It works perfectly if the format of the data in column E remains static. Unfortunately, the data I have can give at least two different messages:
Cell 1 can give
- Account Name: Supplied Realm Name: User ID: Service Name: Service ID: Client Address: Client Port: Ticket Options: Result Code: Ticket Encryption Type:
Cell 2 can give
- Authentication Package: Logon Account: Source Workstation: Error Code:
I would like to amend the macro to taking into account the different format of messages which can be found in column E.
I would be grateful for any help.