Export data to Text file without leaving worksheet.

[rmcompute]

I would like to set up a worksheet where the user can set up a column or
columns of data and then push a button to have the data stored as a tab
delimited text file. I would like to do it without having the user leave the
current spread sheet. Is this possible?

 

[eric]

you can use "data validation" allow option select "list"
Source select worksheet Range