J
JackGombola
I have an Excel 2003 spreadsheet with Lastname Firstname and Teamname as
columns A-C. The sheet is sorted on these three columns in the order stated.
Columns D thru T contain other teamnames played.
I am writing a macro that put's up an InputBox requesting the user to enter
a Lastname, Firstname, Teamname separated by commas such as:
Lastname2,Jill,Team1 to find the row for "Jill Lastname2".
I used the macro recorder to create a macro that does a Find on Col A then B
then C. Problem is, when I find the Lastname in Col A then select Column B
and issue a Find command for the Firstname, the Find starts from the top of
column B when I want it to begin with the row that contained the lastname
successfully found in column A. There is an After: property associated with
the Find command but I don't know how to assign the row number where the
lastname was found to that After: property.
Sample Data
Lastname1 Jill Team1
Lastname2 Jill Team1
Lastname2 Mary Team1
When I enter "Lastname2,Jill,Team1" the first Find in my macro successfully
finds row 2, but the next Find stops at the Jill name in Column B identifying
the wrong row.
Any and all help is appreciated.
Jack
columns A-C. The sheet is sorted on these three columns in the order stated.
Columns D thru T contain other teamnames played.
I am writing a macro that put's up an InputBox requesting the user to enter
a Lastname, Firstname, Teamname separated by commas such as:
Lastname2,Jill,Team1 to find the row for "Jill Lastname2".
I used the macro recorder to create a macro that does a Find on Col A then B
then C. Problem is, when I find the Lastname in Col A then select Column B
and issue a Find command for the Firstname, the Find starts from the top of
column B when I want it to begin with the row that contained the lastname
successfully found in column A. There is an After: property associated with
the Find command but I don't know how to assign the row number where the
lastname was found to that After: property.
Sample Data
Lastname1 Jill Team1
Lastname2 Jill Team1
Lastname2 Mary Team1
When I enter "Lastname2,Jill,Team1" the first Find in my macro successfully
finds row 2, but the next Find stops at the Jill name in Column B identifying
the wrong row.
Any and all help is appreciated.
Jack