how to keep recored daily if a cell value is changing daily

**siddiq1212** · 01-09-2013, 09:44 AM

I have a linked cell C10 in which value is changing daily.I want to keep record of daily changes in seprate sheet.How can i do that.

**Jakobshavn** · 01-09-2013, 10:26 AM

Does cell C10 contain a formula or does it contain a user-entered value?

**siddiq1212** · 01-09-2013, 10:44 AM

C10 contains formula linked by other cell which is changing every day.
i want to copy this values to other sheet so as to have monthly records.

**Jakobshavn** · 01-09-2013, 11:23 AM

That is good. There are many ways:

Put the user in control. When you are satisfied with the value in C10, push a button and the value, date, and time will be recorded elsewhere
Automatic upon close. If the workbook is closed daily, the value, date, and time will automaticall be recorded elsewhere before the save-and-close
Automatic upon change. The first time C10 changes during the day, automatically record the value, date, and time elsewhere.

What is your preference?

**siddiq1212** · 01-09-2013, 11:28 AM

Can you please tell me the procedure

**Jakobshavn** · 01-09-2013, 11:59 AM

Here is a very small sample. Once a day, push the button to record the value in C10. You can record only one value per day.

Macros must be enabled for this to work!