PDA

View Full Version : Need help with assignment -Datafiltration



spiffen
10-08-2008, 04:23 AM
Hey...

Hope someone can :help me!!!

I have this assignment, that gives me a lot of trouble.
A file containing the excel file with the data is attached.
I can start by saying that I'm not that good with VBA codes :banghead:

So any help/little piece of code is welcome

I'll try to describe the assignment as precise as possible
I have an excel file with a "memberrecords"
There's two worksheets - "medlemmer" and "resultater"
And I need to select the members from the the worksheet "medlemmer" who has the following criterias:

Lives in "Odense"
Age between "30-35"
Select sex with a inputboxThe way to determine the sex is with the help of the row "cpr-nr", even number means female and odd numner means male

When the members who meet these criteria is found, selected info has to copied to the other worksheet "resultat.

My biggest problem is creating a code(s) which can select the members meeting the criterias!!!

: pray2:

Kenneth Hobs
10-08-2008, 06:22 AM
If it is a homework assignment, then we can not help due to forum rules posted in the FAQ.

In keeping with the rules, I can tell you an approach. Use a criteria table via the Data > Filter > Advanced Filter...

mdmackillop
10-08-2008, 12:20 PM
If it is a homework assignment, then we can not help due to forum rules posted in the FAQ.

In keeping with the rules, I can tell you an approach. Use a criteria table via the Data > Filter > Advanced Filter...
Agreed. However if you post your code, we can probably assist with where things are going wrong, but don't expect a solution!