Shay
Without wishing to change your plan, this has all the makings of being an
issue waiting for a problem further down the track. Data, Multiple Users,
Buttons, Forms are all best done in a database and maybe analysed in Excel
as the data is entered
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech):
www.nickhodge.co.uk/blog/
"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