Database in excel

[Shay]

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 form/table.

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?

Shay

 

[Gord Dibben]

Shay

Excel has a built-in Data Form that will prpbably fit your needs.

Data>Form will get you started.

For an enhanced Data Form see John Walkenbach's site.

http://www.j-walk.com/ss/dataform/cusomizing.htm


Gord Dibben MS Excel MVP