Hello,

I am working on a very large spreadsheet of data in Excel 2013 Pro Plus edition. I need to have the following functionality to quickly find and bring it to display in the table I am working with. This table is HUGE! Having over 25,000 records of agent ID's, names of Agents, their addresses, phone, email, and the products they sell in their respective districts and sub-districts.

I would like to make use of a simple Userform and have something like this:

-------------------------------------------------------------------------------------------
PID: Text Box
District: Combo Box
Sub-District: Combo Box

RESET BUTTON SHOW DATA BUTTON


TABLE HERE

-------------------------------------------------------------------------------------------

The above is the best I can visualize here. But this is a synopsis of what functionality I am looking for.

The First Text Box will be the PID Text Box, where the user can enter a PID (an agent ID code) and presses the SHOW DATA button, which then displays all relevant information like name of agent, address and other details in the table below. It will essentially work like a search tool.
If the user does not know the PID, he/she can make a search using the District and Sub-District Combo Boxes. The user makes use of the District Combo Box and selects a district and the Sub-District Combo Box automatically updates and loads the correct Sub-Districts corresponding to the District chosen. The user selects a Sub-District from the Sub-District Combo Box and presses the SHOW DATA Button which then displays all the Agents belonging to the District and Sub-District with the details of all the agents working in the particular chosen district. This is basically how this system should work.

Where do I start with this ?
Any help greatly appreciated !
~~ Maneesh