Filter Macro, using number 'position' instead on names

[cooket4]

Hi

I am trying to do a macro which filters a table to show one persons name at a time, then use that name to lookup thair email and email them a remittance.

I have the rest sorted, i think! but I just need a macro to select the name, using the position, i.e 2, 3, 4, 5 etc instead of the name, as the names change

Please Login or Register  to view this content.

The above code is a test to see if I could get the filter to select the first name, but didnt work!

How can I get the filter to select the number position?

When I get this sorted I will be putting a loop untill end. Then add the rest of the code I have, but need this 'simple' bit first

I have excel 2010

Thank You

[krabine]

When you say number instead of name, what do you mean?

You want to select the 2nd name of the drop down list?

[cooket4]

say the list is:

Jayne
Steve
Tom
Wendy

Jane would be number 1
Steve number 2
Tom Number 3
wendy Number 4

When using the macro, the criteria it selects will be "Jane" or "Steve" ect. But I need the Filter Macro to sat Number 1 or Number 2, that was I can put in a loop untill by using "Number" +1

Hope this helps

[cooket4]

Ive cheated abit. I have added a number beside each name via formula.

Please Login or Register  to view this content.

Now I need to figure out how to make the filter criteria "Number" to do "Number +1" in the loop, and change the Do Untill Criteria1:=10 to the end of the filter driteria

Any Suggestions?

Thanks

[krabine]

You mean like this?

Please Login or Register  to view this content.

this will only filter by number, so you can either add a column with a number next to the name, or define what each number means within the code which can get sloppy

[cooket4]

Yes thats it

I can now doa count for the do untill . As some names will be duplicated is there a count unique?

Thanks again

[cooket4]

nevermind, I can do a max on the numbers ive already put in. Im having a thick day!