trevor2524
New Member
- Joined
- Jul 24, 2013
- Messages
- 13
Hello Everybody,
I need helping figuring out how to create a macro for this project. I have about 60k phone numbers in Sheet 1 in Column A in the following format (938) 123-3456 .I need to take the number listed in row 1 on sheet 1 and check it with Columns D-H on Sheet 2 to see if it finds a match. If it finds a match it will highlight the entire row red. The problem that I might run into is that the Columns being checked aren't always in the same setup but the number format is the same. They might have wording before or after the number listed. Once the entire search is done which is about 30k in each column it will go back to Sheet 1 and move one row down in Column A and start all over again. It will need to do this until there are no more numbers to check in Column a. Any help is extremely appreciated. Thank you.
I need helping figuring out how to create a macro for this project. I have about 60k phone numbers in Sheet 1 in Column A in the following format (938) 123-3456 .I need to take the number listed in row 1 on sheet 1 and check it with Columns D-H on Sheet 2 to see if it finds a match. If it finds a match it will highlight the entire row red. The problem that I might run into is that the Columns being checked aren't always in the same setup but the number format is the same. They might have wording before or after the number listed. Once the entire search is done which is about 30k in each column it will go back to Sheet 1 and move one row down in Column A and start all over again. It will need to do this until there are no more numbers to check in Column a. Any help is extremely appreciated. Thank you.
