Text file is ambibuous. Do you want comma delimited, tab delimited, fixed
column?

Do you just need to be prompted with
Use Autofilter, then build the textfile using low level file io

http://www.applecore99.com/gen/gen029.asp

or do you need someone to put up example code?

--
Regards,
Tom Ogilvy

"Kevin R" wrote in message
...
I have a worksheet that has 6 columns. The number of rows can vary. I
need
to filter the worksheet on 3 of the columns to narrow the data down to
what I
need to extract. Then I need to create a text file using the filtered
data
so that cells A1, B1, & C1 are on a line and then D1, E1, & F1 are on the
next line. I need to repeat this in the text file for each row in the
filtered worksheet. Is this possible?