General discussion

Locked

database design in Excel

By sohailabbasi ·
I know MS Access is the most suitable for this but is it possible to create a database in Excel which stores the following:
3 production lines say(A, B, C) and around 9-10 machines on each production line. the database would contain information like machine speed, efficiency, control, Technical Spec etc etc

There could be two combo boxes one for selecting the line and the other for selecting the machine and based on the selection only the data for that particular machine on that line would be diplayed in front of the user.
The other problem is that this database should be easy to maintain ie it should be easy to add/modify/delete a machine in the combo box for a particular line.

many thanks

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to database design in Excel

Here's something to play around with:
1. Somewhere in the worksheet, create three named ranges
a) Type (elements of this named range should be Boy, Girl)
b) Boy (elements of this named range should be S, T, U)
c) Girl (elements of this named range should be X, Y, Z)

2. Select A1:A10, go to Data>Validation>List. Under source, type:
=Type.

3. Select B1:B10, go to Data>Validation>List. Under source, type:
=INDIRECT(A1)

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums