Office Software Thread, Excel ? in Technical; im trying to make a summary sheet where you can select a reporting period in the first list box, but ...
4th April 2011, 11:24 PM #1
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 ?
5th April 2011, 12:22 AM #2
Tricky to know best way do do this without seeing a sample of the data, but the attached file might give you some ideas.
By reecec in forum Office Software
Last Post: 28th April 2010, 08:16 PM
By DaveP in forum Downloads
Last Post: 22nd December 2009, 05:05 PM
By RabbieBurns in forum Office Software
Last Post: 18th November 2009, 08:56 AM
By TechSupp in forum General Chat
Last Post: 9th November 2009, 12:19 PM
By Edu-IT in forum How do you do....it?
Last Post: 7th March 2008, 08:57 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread