Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying an entire worksheet - need absolute values
IN Excel 97
Within the same workbook, I'm wanting to create a new worksheet, but I want it to have the "exact" same values as an existing worksheet. An exact duplicate, however, copying it won't help, because I want it to pick up any changes made to the original worksheet. I want to simply change the rounding for charting purposes, but need it to have same values, so all the cells need to link to the original sheet. Here's a sample of what I've run into. When I tried to use the $ for absolute value (refering to the original sheet), it doesn't pick up that the number is a calculation "and" is converted to a percentage. I'm miffed by it all. Perhaps there's a way to copy, but tell it to link to the original sheet, at the same time (I'm guessing). Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying an entire worksheet - need absolute values
Cow
CTRL + a(twice in 2003) to select all cells. Copy, switch to new sheet and Paste SpecialPaste LinkOKEsc. I think you should also visit Excel Help section for assistance on what the $ signs mean for "Absolute" references. Has nothing to do with absolsute values. Gord Dibben Excel MVP On Mon, 12 Dec 2005 13:05:39 -0800, "Cowtoon" wrote: IN Excel 97 Within the same workbook, I'm wanting to create a new worksheet, but I want it to have the "exact" same values as an existing worksheet. An exact duplicate, however, copying it won't help, because I want it to pick up any changes made to the original worksheet. I want to simply change the rounding for charting purposes, but need it to have same values, so all the cells need to link to the original sheet. Here's a sample of what I've run into. When I tried to use the $ for absolute value (refering to the original sheet), it doesn't pick up that the number is a calculation "and" is converted to a percentage. I'm miffed by it all. Perhaps there's a way to copy, but tell it to link to the original sheet, at the same time (I'm guessing). Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheet but changing format | Excel Discussion (Misc queries) | |||
Entire worksheet moves when moving from cell to cell | Excel Discussion (Misc queries) | |||
copying formulas from worksheet to worksheet | Excel Discussion (Misc queries) | |||
Copying blank excel worksheet into additional excel workbooks | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |