Sharpe2026
New Member
- Joined
- Jul 5, 2019
- Messages
- 2
I am trying to work out a way of identifying individuals in a random list as opposed to non-individuals, where each individual does have a known identifier in a separate list. And then cutting out the entire row where the individual is identified to paste into a separate sheet.
For example in the list below:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
Rows 1, 2 and 5 are individuals, While rows 3 and 4 are companies.
In a separate works sheet I have a list of individuals and their unique identifiers:
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
So i'd like to be able to search the first list for any number contained within the second list and, where it identifies it, cut the row and paste into a third worksheet.
Thank You in Advance
Si
For example in the list below:
A | B | C | |
1 | 26789 | 20 | MR SMITH J BR 45327 |
2 | 26789 | 20 | ALAN TEST TEST ALAN 55859 |
3 | 26789 | 40 | COMPANY FNG27CI3214687564 |
4 | 26789 | 75 | COMPANY QTG75CI39843575 |
5 | 26789 | 40 | J JONES 0000062316 |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
Rows 1, 2 and 5 are individuals, While rows 3 and 4 are companies.
In a separate works sheet I have a list of individuals and their unique identifiers:
A | B | |
1 | J SMITH | 45327 |
2 | A TEST | 55859 |
3 | J JONES | 62316 |
4 | P HILL | 64677 |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
So i'd like to be able to search the first list for any number contained within the second list and, where it identifies it, cut the row and paste into a third worksheet.
Thank You in Advance
Si