A sheet per day is certainly not an efficient way to do it. Two months later
your workbook will already have some 50 sheets and navigation won't be very
easy; retrieving statistical information will be quite complicated; the file
size will go through the roof, etc... Consider twelve months later.
Doing it in, say, MS-Access, or any database software, for that matter,
would probably bear significant advantages, depending on the size and type
of the data and what you want to do with it, but there are still ways to do
it in Excel if you'd rather stick with it, and be much more effircient than
creating a sheet per day.
The general idea is to store all information on one sheet (remember the
65,536 limiton number of rows) in a tabular form, one row per entry, with
data items in columns next to each other, which will aslo make it easy to
transfer to Access (or other db) if you decide so. Having set up the table,
you can make your data entry on a separate sheet to serve as an input form,
or (preferably) create a real form in Excel for the purpose, and use some VB
code (a macro) to ransfer new entries to the table in either case.
If your data manipulation requirements (reporting etc.) are moderate and the
amount of data is not expected to exceed the row limit on a sheet, then
Excel will do the job. If you foresee more data and complicated calculations
or reporting requirements, would like to have data integrity checks, the
data could be normalized etc. and have some working knowledge of a database
software, or are willing to work on it, I would suggest you give it a shot;
Excel has some limited database functionality, but it is not a database
management system.
HTH,
Nikos
