 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-22-2008, 06:06 PM
|
|||
|
|||
|
Prevent change to refs in second worksheet when drag cells in firs
I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among
different locations in the primary calendar worksheet. I have a second worksheet that needs to list those cell values in a fixed configuration, e.g. the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10. Sheet2!G10 contains the formula: “Sheet1!$A$1”. If the user drags Sheet1!A1 to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to “Sheet1!$A$3”. I have tried all combos of locking and protecting to prevent this updating. Is there a way to do this? 
|
|
05-22-2008, 06:20 PM
|
|||
|
|||
|
Re: Prevent change to refs in second worksheet when drag cells in firs
Try referencing the other sheet this way: =INDIRECT("Sheet1!A1")
-- Jim "LarryInBrookline" <LarryInBrookline@discussions.microsoft.com> wrote in message news:A4B595E4-6152-4192-AE93-23549C3688F8@microsoft.com... |I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among | different locations in the primary calendar worksheet. I have a second | worksheet that needs to list those cell values in a fixed configuration, e.g. | the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10. | Sheet2!G10 contains the formula: "Sheet1!$A$1". If the user drags Sheet1!A1 | to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to | "Sheet1!$A$3". I have tried all combos of locking and protecting to prevent | this updating. Is there a way to do this?
|
|
05-22-2008, 07:09 PM
|
|||
|
|||
|
Re: Prevent change to refs in second worksheet when drag cells in
Jim,
Wow, I have no idea what that is yet, but it works perfectly, a million thanks. Larry "Jim Rech" wrote: > Try referencing the other sheet this way: =INDIRECT("Sheet1!A1") > > -- > Jim > "LarryInBrookline" <LarryInBrookline@discussions.microsoft.com> wrote in > message news:A4B595E4-6152-4192-AE93-23549C3688F8@microsoft.com... > |I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among > | different locations in the primary calendar worksheet. I have a second > | worksheet that needs to list those cell values in a fixed configuration, > e.g. > | the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10. > | Sheet2!G10 contains the formula: "Sheet1!$A$1". If the user drags > Sheet1!A1 > | to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to > | "Sheet1!$A$3". I have tried all combos of locking and protecting to > prevent > | this updating. Is there a way to do this? > > >
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
