EXCEL - DISTINCT PICKLIST FROM DATA IN ANOTHER SHEET

[crystalhall]

Hi All,

I'm quite new to complex Excel so please excuse what may be a simple question.

I am dealing with one workbook which has two worksheets named Import and Tracking.

Import has headers B3:H3 and data B4:H1503. The data is being imported from an external database. and is importing correctly.

On the worksheet Tracking, I am displaying columns C to H from the Import worksheet and I would like to know how to create a picklist in cell A1 which will be a distinct selection of the data in Import!(B3:B1503) that when a value is selected, can filter and display the matching values from Import!C3:H1503 below.

Sorry, if I haven't made this very clear.

Thanks in advance for your help.

B.

 

[SkipVought]

hi,

Have you thought of using a PivotTable to select & display your data from the Import sheet?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}