macro to lock sheet cells results @ COB

[simpson]

I have a workbook that keeps track of prices to our customers daily. The workbook has 31 sheets and a master sheet. Formulas on each daily sheet referance prices on the master sheet. I change the master sheet prices daily but need each daily sheet to remain the same so I can go back and see what the prices were on each individual day.
I was thinking a macro that would convert certain cells on each daily sheet to text at midnight every day. or when the date was changed in the master sheet.
Let me know if a sample would help.
thanks in advance.

[arlu1201]

You could have a small macro that goes to the previous day's sheet and paste specials the values.

Maybe if you attach a sample, we can provide more guidance.

[simpson]

Is it possible to get the macro to run automaticlly when the date value is changed on the master sheet?

[arlu1201]

Yes its possible. If you attach a sample workbook, i can help you more easily.