Why not just write a simple macro that copies the worksheet and renames it
to the day's date. You could manually go and purge old unwanted sheets.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<JoJo wrote in message ...
Folks:


I have a small spreadsheet consising of 5 columns & 10 rows of
information.
Each day I manually update this spreadsheet so I end up with a new set of
data in the rows & columns.
But this means that the previous day's data is lost.

* Is there a way to create (then save) each day's data to a database so
that I can always go back to check on the old data ?

When I enter data in the spreadsheet, it should get stored in this
database.
The spreadsheet is merely acting like a FORM thru which data gets sent to
the database.



Thanks,
Jo..