Saving Multiple Worksheets

[Guest]

I have created an Excel workbook which contains 3 separate worksheets - the
worksheets are named Quotation, Terms and Conditions and working data.

Quotation and Terms and Conditions are supposed to be sent to customers,
whilst working data remains behind.

My problem is that I am unable to save or send only the sheets that are
required; all of the worksheets are sent and/or saved..

Is there a method in which I can choose to only send or save the requiried
sheets??

Any guidance is appreciated.

 

[Guest]

I don't know about sending just certain worksheets but I know you can "hide"
a worksheet. Not sure about the Excel version you are using but on mine, you
go to Format | Sheet | Hide. Then you can send your file to your customers.
If you are using information from the working data sheet to complete the
other 2 worksheets, I don't think you have any other option.

Good luck!

 

[Guest]

You can hold the ctrl button and select the 2 worksheets that you want to copy
Then right click on one of the sheets that you have highlighted and select
Move/Copy. A dialog box will pop up
In the drop down To book: Select (new book) and make sure you put a check
mark in the box Create a copy

Should do it

 

[RagDyeR]

Check out this link of Ron deBruin, which has everything for mailing files.

http://www.rondebruin.nl/mail/add-in.htm

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have created an Excel workbook which contains 3 separate worksheets - the
worksheets are named Quotation, Terms and Conditions and working data.

Quotation and Terms and Conditions are supposed to be sent to customers,
whilst working data remains behind.

My problem is that I am unable to save or send only the sheets that are
required; all of the worksheets are sent and/or saved..

Is there a method in which I can choose to only send or save the requiried
sheets??

Any guidance is appreciated.

 

[Gord Dibben]

Sherry

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 or selected sheet 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