Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default How do I save part of a worksheet in a separate file?

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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,268
Default How do I save part of a worksheet in a separate file?

Copy the small selection into a new workbook

--
Regards,

Peo Sjoblom



"cleo" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default How do I save part of a worksheet in a separate file?

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.

"Peo Sjoblom" wrote:

Copy the small selection into a new workbook

--
Regards,

Peo Sjoblom



"cleo" wrote in message
...
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?




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I save part of a worksheet in a separate file?

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

On Mon, 14 May 2007 14:40:02 -0700, cleo wrote:

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.

"Peo Sjoblom" wrote:

Copy the small selection into a new workbook

--
Regards,

Peo Sjoblom



"cleo" wrote in message
...
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i save worksheet as a jpeg file jaxrob New Users to Excel 3 March 8th 07 11:51 PM
copy part of a worksheet into a worksheet in the same file/keepi. JTB Excel Worksheet Functions 1 September 23rd 06 09:13 AM
How to save a worksheet seperately in addition to part of wrkbook Ron de Bruin Excel Discussion (Misc queries) 5 September 14th 06 07:57 PM
Can I auto save to a separate file?(not the file I am working in) Jim Lynch Setting up and Configuration of Excel 1 August 14th 06 05:20 PM
Save 2 separate data imports in separate worksheets on the same ex Jay Excel Worksheet Functions 1 March 8th 06 02:31 PM


All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"