Nick is absolutely correct - don't do this in Excel. Microsoft has templates
for Access databases (and a database is where you want to create this).

You might be able to easily modify this to suit your needs

http://office.microsoft.com/en-us/te...CT101428511033

"Shay" wrote:

Hi all,
I'm looking to create a database in excel to record Utilities usages
e.g.
Water
Electricity
Oil
Gas etc....

How can I do this to make it easy for people to input the data? (at
the min
we have many files with no organisation)

E.g. In sheet 1, can there be a row of buttons such as Water, Oil
etc.. when
one is clicked it'll go to a page where the data can be inserted -
Like a
small field.

When this data is inputed it'll also go into a table (e.g. in a sheet
called
"Water Data").

With this system.. it'll make it easy for anyone to log this data.

Does anyone know of any examples/templates i can use?

Many thanks for any help :-)

Shay