Results 1 to 8 of 8

lock cell formula result, even if source data changes

Threaded View

simpson lock cell formula result,... 12-05-2011, 11:57 PM
Vinodsralian Re: lock cells on worksheets... 12-06-2011, 01:49 AM
simpson Re: lock cells on worksheets... 12-06-2011, 06:14 PM
simpson Re: lock cells on worksheets... 12-07-2011, 12:41 PM
simpson Re: lock cell formula result,... 12-07-2011, 04:38 PM
JBeaucaire Re: lock cell formula result,... 12-18-2011, 04:26 AM
Vinodsralian Re: lock cell formula result,... 12-19-2011, 07:22 AM
pike Re: lock cell formula result,... 12-19-2011, 10:20 PM
  1. #1
    Forum Contributor
    Join Date
    06-27-2009
    Location
    montana,USA
    MS-Off Ver
    Excel 2007
    Posts
    190

    lock cell formula result, even if source data changes

    I have a workbook that i use daily to figure pricing to our customers. the master sheet has the date and the price, and so do the per day sheets. When i change the date and price on the master i need the price on the corrisponding sheet to lock in and not change.
    is this possible?
    example;
    on master date 1-1-11 price = 3.33
    on sheet 2 price = 3.33

    on 1-2-11 I change the master price to 3.35
    on sheet 2 the price remains 3.33
    on sheet the price shows 3.35

    thanks in advance
    Attached Files Attached Files
    Last edited by simpson; 12-07-2011 at 04:27 PM. Reason: hoping for a solution

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1