Filter List

**blurtoad** · 06-25-2007, 09:15 AM

Hello. Please see the attached Xls file.

I have 3 worksheets:

(a) Raw_Data - source data that I input

(b) Selection - Here, user select the filter criteria by indicating '1'

(c) Output - where the filter will find the correct data from Raw_Data and output to.

Could any kind soul please help me? My headmaster is asking me to get this done by the end of this week and I have no clue on how to even start. Thank you so much for your kind assistance.

**blurtoad** · 06-25-2007, 09:23 AM

Thank you once again.

**royUK** · 06-25-2007, 11:46 AM

Where's the attachment?

**blurtoad** · 06-25-2007, 12:30 PM

Attached is a zip file containing the .xls

**royUK** · 06-25-2007, 01:25 PM

Do you mean the user places a 1 next to the filter criteria? If so why is 8 & 9 indicated?

**blurtoad** · 06-26-2007, 01:58 AM

The user puts 1 on the items that he wants to choose (ideally, one could choose via a drag down list with multiple select enabled).

There are 3 fields that are found in the data base, namely "SUBJECT", "YEAR" (of students) and "COUNTRY".

So, based on the xls file, what the user have selected is to look for students from Greece who are attending Year 8 or Year 9 whose best subject is Economics.

Hope this clarifies the problem.

**blurtoad** · 06-26-2007, 11:54 AM

I really need to get this done. Please help. Thank you.

**blurtoad** · 06-27-2007, 12:47 PM

I sincerely appreciate any kind soul who could offer his help. Thank you.

**royUK** · 06-27-2007, 01:10 PM

have you tried anything, maybe using the Macro Recorder?

http://www.excel-it.com/record_macro.htm

if you switch the Recorder on a perform the Filter you will get some basic code which can be tidied up.