Filter from listbox

[Former Member]

Hi all,

I'm trying to extend my dashboard with additional data from another spreadsheet using the filter option.

My data looks like:

Sheet 1: (data listed in columns)

Project Name:

Project ID:

....

Sheet 2: (data listing in rows)

Project ID:

Child Project

...

I would like to use the listbox to filter the child projects from Sheet 2.

Is there an easy to do this.

Thanks,

Lee

[Former Member]

Best way would be to merge the tables into one with VLOOKUP in Excel and then use Listbox with Filtered Rows.