How do I save part of a worksheet in a separate file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large worksheet that I need intact. I want to save a small section
of it as a separate file. Can I do that in Excel 2003?
 
That's what I was afraid the answer was. I just get very tired doing that
when different employees need different parts. I need to email them the parts
that pertain to them and not the rest of the spreadsheet. I update all the
time and email often. It seems like if I can print only one area, I should be
able to save only one area under a different file name.
 
cleo

If you do this a lot see Ron de Bruin's site for automating with VBA.

http://www.rondebruin.nl/sendmail.htm

You can send just a selected range as a new workbook.

His Sendmail add-in is very useful so a download and install may be worth the
effort in the long run.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

How do I save a page in a workbook as a separate file? 4
Save Workshetts as Separate Files 2
HOW DO I COLLECT TEXT DATA FROM A COLUMN 2
excel function solve problem? 2
Close all without saving and exit without prompts 8
How do I save only active worksheet without save all of worksheet 1
How do I split a sheet so I can have different amount of columns? 1
How to separate Excel Workbooks into new files 0

Back
Top