| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sending only part of a workbook thru emai
I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of
calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
You could just right-click on the sheet tab and "move or copy".
Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
Because sheet three is driven by calculations in other sheets--after I copy
it to a new workbook it asks if I want links updated? If i just say no and send the new workbook out to people will they get that same message also when they try to open it? Carl "Gord Dibben" wrote: You could just right-click on the sheet tab and "move or copy". Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
Hi carl43m
There is a example in my code to change the formulas to values There is a option in my add-in to do this also If you want to do it manual see http://www.rondebruin.nl/values.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "carl43m" wrote in message ... Because sheet three is driven by calculations in other sheets--after I copy it to a new workbook it asks if I want links updated? If i just say no and send the new workbook out to people will they get that same message also when they try to open it? Carl "Gord Dibben" wrote: You could just right-click on the sheet tab and "move or copy". Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
After copying to the new book, select all cells and EditCopy
Then EditPaste SpecialValuesOKEsc. Now save and send. Gord On Thu, 14 Dec 2006 11:43:02 -0800, carl43m wrote: Because sheet three is driven by calculations in other sheets--after I copy it to a new workbook it asks if I want links updated? If i just say no and send the new workbook out to people will they get that same message also when they try to open it? Carl "Gord Dibben" wrote: You could just right-click on the sheet tab and "move or copy". Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
Thanks!
"Gord Dibben" wrote: After copying to the new book, select all cells and EditCopy Then EditPaste SpecialValuesOKEsc. Now save and send. Gord On Thu, 14 Dec 2006 11:43:02 -0800, carl43m wrote: Because sheet three is driven by calculations in other sheets--after I copy it to a new workbook it asks if I want links updated? If i just say no and send the new workbook out to people will they get that same message also when they try to open it? Carl "Gord Dibben" wrote: You could just right-click on the sheet tab and "move or copy". Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sending only part of a workbook thru emai
You're welcome and sorry for not thinking of that first time around.
You did say sheet3 "pulls" data from the other 2 sheets. Gord On Thu, 14 Dec 2006 13:53:01 -0800, carl43m wrote: Thanks! "Gord Dibben" wrote: After copying to the new book, select all cells and EditCopy Then EditPaste SpecialValuesOKEsc. Now save and send. Gord On Thu, 14 Dec 2006 11:43:02 -0800, carl43m wrote: Because sheet three is driven by calculations in other sheets--after I copy it to a new workbook it asks if I want links updated? If i just say no and send the new workbook out to people will they get that same message also when they try to open it? Carl "Gord Dibben" wrote: You could just right-click on the sheet tab and "move or copy". Copty to a new workbook. Save that and send it. Alternative is Ron de Bruin's site for individual sendmail code methods. http://www.rondebruin.nl/sendmail.htm If you download his SENDMAIL add-in you will have all the options at your fingertips. Gord Dibben MS Excel MVP On Thu, 14 Dec 2006 08:39:00 -0800, carl43m wrote: I have a workbook with three sheet tabs. Sheets 1 &2 do a bunch of calculations and generate the information I need to develop schedule for me. In sheet 3 I pull data from the first two sheet into a predefined format that is organized into a comprehensive schedule of activities . My question is this. I want to be able to send the information from sheet 3 to people thru email but I don't want to send the whole workbook that contains my calculations/formulas and other data they don't need to see that is in sheets 1 and 2. Is there a way to get the data from sheet sent without the rest of the workbook? Thanks Carl Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying Part Numbers | Excel Worksheet Functions | |||
| worksheet to worksheet . . . | Excel Worksheet Functions | |||
| How do I match 2 cols on two books and get price info for all matc | Excel Worksheet Functions | |||
| excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
| sending object to the back in excel workbook | Excel Discussion (Misc queries) | |||
Linear Mode
