Well here goes. I have already built a macro (with the help of reading
from the group...thx)that will allow me to open a specific text file
in excel.

Now after opening the file I need to sort/parse all of the information
into specific columns and place the data that occurs after the keyword
in that column.

My thoughs were to create a loop that would key off of those words and
capture all data until the next keyword occurred. I would normally use
awk on something like this but those tools are not available to me.
So... I guess I am asking is this possible with excel macros or should
I use other tools.

I am I heading in the wrong direction????

Here is an abrivated sample of the file:
system_name sys_1 sys_2 sys_3 user_table administrator user_1 user_2
user_3 group administrator dba sap

What I need to do is have the module key off of the terms system_name,
user_table, group and capture the data after that keyword and place it
into the column under each keyword.

Example:

system_name user_table group
sys_1 administrator administrator
sys_2 user_1 dba
sys_3 user_2 sap