Any expart who can help me to develop a Macro in Excel with the help of VBA by getting a datas from the txt file.
Actually I have a data file in txt format which contents the different sets of numeric and chartacter type datas. It invokes by the different command. I wants to create a worksheet to represent this datas in a tabuler form with the help of Macro. I want to create a macro which ask for the file name, after given the file name, it will search a data based on given conditions and retrive a values under the given conditions. Its an reperative task. Also there are some calculations based upon the type of datas it displayed (i.e. like if its internal then display with red color, if its external then display with green color then calculate total red & green color values etc.).
Anybody who can help me will be appriciated by solving my big problem and save my job. If they need a data file and the format in which I want to present, I can send him.
