How do I send some cells to an external text file?

L

lothario

Hello,

I have a spreadsheet in which:

Column 1 contains (a number) price per unit.
Column 2 contains (a number) quantity.
Column 3 contains (a formula) sub-total. (price per unit x quantity)
Column 4 contains (a number) sales tax rate.
Column 5 contains (a formula) total. (sub-total x sales tax rate) +
sub-total

I need to give this spreadsheet to a person who has no Excel
knowledge.

Please help:
How can I have the user click a button (or something like that) so that
the above information is automatically written to an external text
file?
This auto generated text file should NOT contain the formulas.
This auto generated text file should contain ONLY the values. Such
price per unit, quantity, sub-total, sales tax rate and total.

The text file will be printed as a "receipt".

Thanks,

Luther
 
T

Tom Ogilvy

The user only has to do File=>Saveas and Select "save as type" to be .CSV

That should be simple enough to explain.

Why send the .CSV file. Then they have it.
 

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

Top