Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 10:05 PM posted to microsoft.public.excel.worksheet.functions
Cowtoon
 
Posts: n/a
Default 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   Report Post  
Old December 12th 05, 11:08 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying worksheet but changing format Glissader Excel Discussion (Misc queries) 1 June 3rd 05 05:07 PM
Entire worksheet moves when moving from cell to cell Al Excel Discussion (Misc queries) 3 April 21st 05 12:56 AM
copying formulas from worksheet to worksheet yesbob Excel Discussion (Misc queries) 1 February 7th 05 03:25 AM
Copying blank excel worksheet into additional excel workbooks Deb Excel Discussion (Misc queries) 10 February 4th 05 01:25 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM


All times are GMT +1. The time now is 10:56 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017