+ Reply to Thread
Results 1 to 2 of 2

Static Cell Value in Reference with Dynamic one?

  1. 01-11-2011, 02:34 PM #1
    Rick-O-Shay
    Rick-O-Shay is offline
    Forum Contributor
    Join Date
    12-30-2009
    Location
    US
    MS-Off Ver
    Excel 2003, 2010, 2016, 2019, & Office 365
    Posts
    194

    Static Cell Value in Reference with Dynamic one?

    Hi,

    I am racking my brain out here. How do I write this in a forumla:

    If C16="Apple" then E16= the value in cell C3.

    The problem comes in that the value in cell C3 changes all the time with a VBA script I wrote, but I want the value in E16 to show what is in cell C3 but not change when cell C3 is updated.

    Make sense?
    Reply With QuoteRegister To Reply
  2. 01-11-2011, 02:50 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Static Cell Value in Reference with Dynamic one?

    ... I want the value in E16 to show what is in cell C3 but not change when cell C3 is updated.
    Those are conflicting requirements, are they not?
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1