storing read only data

[Guest]

I work for a powder coating company and want to make a program that will store all of the data on each part. I want to be able to go to the computer type in a part number and retrieve all of the data for that part. It has to be read onlyso that it can only be edited by a supervisor. I was told i could use excel for this and an "at" function was mentioned. thank you

 

[Dave Peterson]

If the info fits in 256 columns, you can put the part number in column A and the
info in B:IV.

Then apply data|filter|autofilter and use that to just show the parts you want.

If the data is more than 256 columns, you could put a "sequence number" in
column A, the part number in column B and info in column C.

Each part number could have multiple rows--the sequence number would go from 1
to xxxx. Then you could filter on the part number and see just the stuff for
it.

Just a tip. If you have to make a decision on where to put the data, try to
make it as granular as possible. Put each piece of info in a different
field/column. It'll make changes easier (as well as working with it).

 

[Dave Peterson]

And just save that file with a password that only the supy knows.

It's under File|SaveAs, then Tools|General Options (in xl2002)
(I think this is hidden under File|SaveAs|Tools|Options in earlier versions.)