Excel ?

[jimbojames136]

im trying to make a summary sheet where you can select a reporting period in the first list box, but then in the second list box it only shows the avaliable options for that reporting period chosen in the first list box? and then display results using a vlookup for that particular reporting period and subject.

 

also if all is selected in the first list box then everything is show in the second list box

 

any ideas ?

 

 

 

thanks

 

James

[andy_b]

Tricky to know best way do do this without seeing a sample of the data, but the attached file might give you some ideas.

example.xls