A
Alex Heath Ratcliffe
I have a rather large table of software.
Column 1 is the software title.
Colomn 2 is the software format. e.g: DVD, PC-Game, Xbox,
PS2.
There are other assorted columns.
On another sheet, I have 2 drop down lists.
The first is to select the format.
The second to select the title.
Obviously, the format field on the table AND on the other
sheet both use a dropdown list linked from a list on
another sheet.
I want the second drop down list to show the titles of
all software items that are of the first drop-down's
current format selection.
e.g: if drop-down 1 reads: Xbox, drop-down 2 would
display the list of Xbox games available on the software
table. (If that makes any sence)
Any help would be great,
Alex
ratcliffe_alex@hotmail[dot]com
Column 1 is the software title.
Colomn 2 is the software format. e.g: DVD, PC-Game, Xbox,
PS2.
There are other assorted columns.
On another sheet, I have 2 drop down lists.
The first is to select the format.
The second to select the title.
Obviously, the format field on the table AND on the other
sheet both use a dropdown list linked from a list on
another sheet.
I want the second drop down list to show the titles of
all software items that are of the first drop-down's
current format selection.
e.g: if drop-down 1 reads: Xbox, drop-down 2 would
display the list of Xbox games available on the software
table. (If that makes any sence)
Any help would be great,
Alex
ratcliffe_alex@hotmail[dot]com