Export highlighted data

[robotman]

Is there a way to export a highlighted section of a worksheet to a
text file? Or is there a way to only export parts of a spreadsheet
that have data in them?

For example, I have a spreadsheet with many hidden formulas from rows
1 - 100. Sometimes only rows 1-12 have data. If I save the
spreadsheet as text, the empty rows (13-100) show up with a set of
columns.

For compliance reasons, I can not incorporate a macro.

Any ideas?

Thanks!

 

[Earl Kiosterud]

The Text Write Program at www.smokeylake.com lets you select one range, which it will write
to a text file, with options.

 

[Earl Kiosterud]

Unless it's specifically not workable, you should put all the data into one sheet. A column
for month. A column for year. Life will be a lot easier. See "Data across multiple
sheets" at http://www.smokeylake.com/excel/excel_truths.htm.

 

[Earl Kiosterud]

Sooorrreeeeee. Wrong post.