need help with an excel spreadsheet

  • Thread starter Thread starter russell
  • Start date Start date
R

russell

I have an excel spreadsheet where questions are answered in one area,
and the answers show up on a form in another area of the sheet that
gets printed. Instead of printing, how can I either email the print
area or have just the print area saved as a file? And, with a macro,
can the new file be named automatically by what's in a particular
cell?

Thanks,
Russ
 
You don't say whether the recipient would need to edit the data. If not,
there are numerous programs available (free, shareware and commercial) which
enable print output to be stored as a PDF file.

Another option would be to copy the data (values only) to another workbook
and save that.
 
Back
Top