Export data to Text file without leaving worksheet.

R

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?
 
E

eric

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delimited text export 3
Excel 2013 Merge Data 2
Auto Copy Data from one worksheet to another 1
Export records into a text file based on criteria 6
Insert into the Worksheet Menu Bar 2
Word to Excel: Export comments with text and line number 0
Make a maro run upon leaving a cell 0
Open delimited text file to excel without changing data in that file 1

Top