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. |
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. |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com