Results 1 to 2 of 2

Filtering Data by Using ListBox Selection to Display All Data in Set Range

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2019
    Location
    Hampton, Virginia
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    18

    Filtering Data by Using ListBox Selection to Display All Data in Set Range

    Greetings again,

    I have a "Data" sheet that contains a breakdown of our annual performance report. Right now, I have it working correctly, but only by individual ranks. I want to be able to
    view the entire listing by selecting "ALL RANKS" in the ListBox. I added this after doing my review on this. What I am trying to do is the following.

    If my drop down ListBox contains "ALL RANKS" then display all data in the "Data!B2:E2" range, starting on the "Dashboard" page under "Member" in C22
    if it ListBox contains other ranks, I want to leave the function alone (i.e. if I click "TSgt" in the ListBox it will automatically populate the "TSgt")

    I have attached the workbook I am using to help make this easier. I truly appreciate everyone's help in this quest.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 09-30-2016, 02:08 PM
  2. Problem with filtering data in a listbox using a combobox value
    By lboromark in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-27-2015, 06:47 AM
  3. Auto filtering the data in listbox and input in specified data range
    By haridevadiga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2013, 06:02 PM
  4. Listbox to display value if certain amoutn of data in a range
    By dwilkinson12 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-23-2013, 03:15 PM
  5. display data based on selection from listbox, total newbie
    By trek4heroes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2012, 08:44 PM
  6. Filtering Pivot table on the basis of Listbox selection
    By protocol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2011, 01:59 AM
  7. [SOLVED] Filtering data to a userform listbox
    By Kryer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2005, 06:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1