Create a Worksheet by getting datas from the txt file with Macro
 

I have a different datas in txt file. I want to create a worksheet with the
help of this txt file datas with the help of excel macro. My txt file doesn't
fit in excel worksheet becasue of the limitation of columns in excel. When I
retrieve my datas, it comes in three sheets. In my txt file, there is a
search condition to search a particular words and then display the
informations in worksheet which is comes under the search word. Is there
anybody how can help me to solve my this problem. I can send the sample of my
txt file and worksheet format if anybody interesting to solve my problem.