Export help please?

  • Thread starter Thread starter John O'Boyle
  • Start date Start date
J

John O'Boyle

I need to be able to output 10 or 15 lines of "selected area" (5
columns, 10-15 rows) data each month to a flat (or text) file. It seems
like it should be a no-brainer, but I'm damned if I can figure out how
to do it. Can anyone steer me in the right direction? "Save as" saves
the entire sheet. I can't seem to find (what I expected to be) an
"export" function.

Thanks for any and all help. I'm seriously stuck!

JLOB
 
John,

1) Select your cells, Ctrl-C to copy them, open up Notepad, and paste, then
save the file.
2) Copy the cells, then paste them onto a new sheet, and then do the
save-as.
3) Use a macro. Repost here if you want to do it that way.

HTH,
Bernie
MS Excel MVP
 
Thanks. That worked just fine, as soon as I found the "Space delimited
..prn" "Save as" type.

J.
 
Back
Top