Database to record cell history

Hello,

I have attached an Excel workbook which should help demonstrate what I will try to explain below;

I want to create a database - preferably in Excel (I have no Access experience, but open to learning if it is more suitable) - that will:

{1) On a "home page" allow you to enter (in my attached example) some key weather parameters for a particular date;
{2) Save parameters entered for a particular date to a "database" on a separate workbook sheet;
{3) Then allow you to overwrite these parameters for a new date on the "home page", while recording (cell) history in the "database".

Any help would be appreciated.

Thanks in advance,

Calum.

Hi,

If you are open to a MS Access, here is a quick example.

Attached is a MS Access in a zipped file.

Cheers