+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1
    jimbojames136's Avatar
    Join Date
    Mar 2011
    Location
    Hull
    Posts
    29
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Excel ?

    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

  2. #2

    Join Date
    Apr 2007
    Location
    Birmingham
    Posts
    142
    Thank Post
    6
    Thanked 45 Times in 39 Posts
    Rep Power
    23
    Tricky to know best way do do this without seeing a sample of the data, but the attached file might give you some ideas.
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. EXCEL - Recording survey details in excel - Easiest way
    By reecec in forum Office Software
    Replies: 2
    Last Post: 28th April 2010, 08:16 PM
  2. Replies: 1
    Last Post: 22nd December 2009, 05:05 PM
  3. [MS Office - 2003] Excel checkbox
    By RabbieBurns in forum Office Software
    Replies: 2
    Last Post: 18th November 2009, 08:56 AM
  4. Help with Excel Chart
    By TechSupp in forum General Chat
    Replies: 3
    Last Post: 9th November 2009, 12:19 PM
  5. Excel
    By Edu-IT in forum How do you do....it?
    Replies: 13
    Last Post: 7th March 2008, 08:57 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •