Of course this is possible. The way I would implement it would be usin
Data/Autofilter.

I assume that you used the macro recorder to create the macro you no
have for importing the text file.

Do the same thing. Turn on the macro recorder, import the text file.
With the macro recorder still on, select the header in the column yo
want to do the selection with. Hold down the Ctrl key and press th
down arrow. From the menu, select Data Filter AutoFilter. Clic
on the arrow next to the header. Select the criterion you want (th
letter "A"). Hit the F5 key (go to). Click on the Special button.
Click the radio button next to Current Region, then click OK. Copy th
selected range. Go to another sheet and paste. Go back to th
original sheet and, from the menu, select Data Filter AutoFilte
again to turn off the AutoFilter.

Turn off the macro recorder

--
Message posted from http://www.ExcelForum.com