Software

Ask something
Discussion Locked

database design in Excel

0 helpful
1 reply

by sohailabbasi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by dklippert

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)

This discussion is closed to new replies.