everblazing
Board Regular
- Joined
- Sep 18, 2015
- Messages
- 156
I am trying to build a macro which i appreciate any help with..
I have data in sheet 2 which consists of 30 agent Id's.
In sheet 1 different agent Ids are entered in column p. I would like a search box that can match and highlight the Agent number entered, if matching any of the agent Id's in sheet two column C.
An example of this is if agent id entered in search engine on sheet one consist of, CF66657 or 4589 or 84589 it can search the data from sheet two anywhere in column C and highlight it if matching on sheet 1. if no data was matching then come up with a message or any notification to advise no match found just so that i know there were no agen Id's in sheet 1 matching Sheet 2 cllumn C.
Thank you
I have data in sheet 2 which consists of 30 agent Id's.
In sheet 1 different agent Ids are entered in column p. I would like a search box that can match and highlight the Agent number entered, if matching any of the agent Id's in sheet two column C.
An example of this is if agent id entered in search engine on sheet one consist of, CF66657 or 4589 or 84589 it can search the data from sheet two anywhere in column C and highlight it if matching on sheet 1. if no data was matching then come up with a message or any notification to advise no match found just so that i know there were no agen Id's in sheet 1 matching Sheet 2 cllumn C.
Thank you
