Hoping someone can help me with this problem I have. I need to have an excel sheet search for a set of numbers in a specific tab. Then if it finds that number, then place the word used or highlight it in some way. So there are tag numbers that are put in a sheet. There are 12 sheets named from January to December. The tags are put in these sheets but only specific ones need to be monitored. I would like to either highlight them in some way or, even better, next to the tag numbers that are being monitored, put what sheet they are on. Cell information would be helpful as well but I am trying to keep this simple. I don’t think VBA works here so I have been trying to figure out a formula to get this to work. I can't post the excel sheet to show but here is what the tables look like:
<tbody>
</tbody>
Sheet Name: TECH ASSET TAGS
All other sheets are named: JANUARY - S0 & Asset all the way through DECEMBER
Each sheet looks like this:
<tbody>
</tbody>
| Used? | Tech Assets | Location | Cell | |
| 123455 | #NAME? | |||
| 12222 | 12222 | |||
| 12333 | 12333 | |||
| Yes | 33333 | 33333 | APRIL - S0 & Asset | D3 |
| Yes | 23456 | 23456 | JANUARY - S0 & Asset | D4 |
<tbody>
</tbody>
Sheet Name: TECH ASSET TAGS
All other sheets are named: JANUARY - S0 & Asset all the way through DECEMBER
Each sheet looks like this:
| Total | Assets: | 2 | |||||
| S0 | Number | Asset Tag | Date | Description | Location | Serial | Tracking Number |
| S0 | 3423423 | 12558 | 1/5/2017 | OPTIPLEX SMALL 7040 | building 7 | 4jkl4kj4kj4kj | z123456789 |
| S0 | 3423423 | 23456 | 1/5/2017 | OPTIPLEX SMALL 7040 | building 2 | kjlwekjndfsnk | z123456789 |
<tbody>
</tbody>
