Database in Excel
 

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

Database in Excel
 

You have a reply in your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Shay" wrote in message ups.com...
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