Export highlighted data

  • Thread starter Thread starter robotman
  • Start date Start date
R

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!
 
Back
Top