I am having major dramas trying to figure out how to get the information in
my dropdown list to show unly filtered data. I will try to explain what I am
doing and hopefully someone can help me. By the way I have no idea how to do
Macros or any VB stuff so Please if you have a solution an easy explanation
would be appreciated.

I have about 50 columns of data and about 4000 rows in sheet 2. This is a
database auto refresh query I have created. The data in this sheet needs to
show in sheet 2 as it is refreshed each time but only column A needs to be
seen based on the criteria in column J having something in it (NONBLANK) so
basically if there is nothing in column J I do not want the data to show up
in the list on sheet 1.

I have done a basic filter on sheet 2 but if I try to create a link on sheet
1 to column A so all the names show I am still getting all the filtered
(BLANK) cells show up. I know I can just copy the information over once I
have done the filter but this is not going to help me as I need it to auto
refresh each time the cells change.

Is there an easy way to filter from one sheet to another and have it so the
criteria is to only show names from column A that are not blank in column J?

I really hope waht I am asking makes sense.

Tahnks