| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying only the numerical values
Is it possible to have a summary worksheet in an Excel spreadsheet and then
copy this worksheet on its own to another document but with the numerical values only? I have a worksheet which is a summary of various other Excel documents linked together. I wish to email this summary page with the numerical values only. I don't particularly want the file paths showing in the document I email - I just wish the numerical values - not the formulas which produce these values. Is this possible? Without going through complicated procedures. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying only the numerical values
"SM" wrote in message ... Is it possible to have a summary worksheet in an Excel spreadsheet and then copy this worksheet on its own to another document but with the numerical values only? I have a worksheet which is a summary of various other Excel documents linked together. I wish to email this summary page with the numerical values only. I don't particularly want the file paths showing in the document I email - I just wish the numerical values - not the formulas which produce these values. Is this possible? Without going through complicated procedures. Ignore this - I just copied the page and used paste special. Don't I feel a fool knowing how simple it was. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Copying only the numerical values
So how do you copy just the numerical values?
"SM" wrote in message ... "SM" wrote in message ... Is it possible to have a summary worksheet in an Excel spreadsheet and then copy this worksheet on its own to another document but with the numerical values only? I have a worksheet which is a summary of various other Excel documents linked together. I wish to email this summary page with the numerical values only. I don't particularly want the file paths showing in the document I email - I just wish the numerical values - not the formulas which produce these values. Is this possible? Without going through complicated procedures. Ignore this - I just copied the page and used paste special. Don't I feel a fool knowing how simple it was. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formula results into cells with numerical formats | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Associated Numerical Values | Excel Discussion (Misc queries) | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Setting up and Configuration of Excel | |||
| Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
