Hi everybody,
I've been looking on the board how to do this but I can't quite find it.
I am trying to write a macro that will search for a certain value (located in sheet 2, A1) in sheet 2 (column A1:A500). I want it to copy all rows with that value. But the thing is I only want the rows where the beginning of the database matched the search criteria.
E.g.
Search criteria: ABC
Database list:
1) ABC
2) ABC
3) ABCD
4) ABCD
5) ZABC
6) 12ABC
I only want nr's 1-4 and not 5 and 6 (what find usually gives).
Any ideas?
NDude
I've been looking on the board how to do this but I can't quite find it.
I am trying to write a macro that will search for a certain value (located in sheet 2, A1) in sheet 2 (column A1:A500). I want it to copy all rows with that value. But the thing is I only want the rows where the beginning of the database matched the search criteria.
E.g.
Search criteria: ABC
Database list:
1) ABC
2) ABC
3) ABCD
4) ABCD
5) ZABC
6) 12ABC
I only want nr's 1-4 and not 5 and 6 (what find usually gives).
Any ideas?
NDude