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:
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: