Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 6
Default Updating the source of a linked cell

Hi all,

I have a question about linked cells. Let's say that I have a cell B2
with value 5. I have another cell C4 which I want to display the value
of B2 but also be able to change its value if I enter in a new value.
I'm pretty sure it's not possible, but I thought I should ask people
who are more familiar with excel.

I think this is useful if you want to display values from a range in
another sheet but still have an active link to the data to update it. I
was trying to see if there is a way of embedding a cell within another
cell, but there doesn't seem to be a way.

Any insight would be appreciated.

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Updating the source of a linked cell

A cell can contain a formula (delivering a value), or a constant value
but not both simultaneously.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

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
The absolute referenced cell does not move when source cell moves johnc Excel Worksheet Functions 2 May 8th 06 06:33 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Conditional Formatting a Linked Cell Danny Excel Discussion (Misc queries) 2 April 24th 06 09:49 PM
Replacing Linked Cell Values w/ Current Values TomCat Excel Worksheet Functions 6 April 10th 06 12:20 PM
Link - deactivate being sent to source when click on linked cell? snidely Excel Worksheet Functions 1 January 11th 05 02:11 AM


All times are GMT +1. The time now is 11:15 PM.

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

About Us

"It's about Microsoft Excel"