lock cell formula result, even if source data changes

[simpson]

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

[Vinodsralian]

I feel if you have macro which copies the data from master to your sheet2 when you need, should solve this prob!!

[simpson]

anyone else have an idea?

[simpson]

Would this be possible if I made the price cell lock based on data in another cell on the daily sheet? Is it even possible to lock the result of a formula in a cell even if the source data changes?

[simpson]

I edited my post. Maybe my question will be clearer.
anyone got an idea?

[JBeaucaire]

I'd take a shot if I had any idea what this means. Your sample workbook doesn't make it any clearer.

[Vinodsralian]

Based on what I understood, I guess this should work with little tweaks, place this macro on your sheet2

Public Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

ActiveSheet.Unprotect Password:="mypassword"
Sheet1.Range(Target.Address).Copy
Sheet2.Range(Target.Address).PasteSpecial

If Not Intersect(Target, Range(Target.Address)) Is Nothing Then
ActiveSheet.Unprotect Password:="mypassword"
Target.Locked = True
ActiveSheet.Protect Password:="mypassword"
End If

End Sub

Hope it helps!!

Vinod

[pike]

Vinodsralian

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here