MRT The Duck
New Member
- Joined
- Nov 12, 2019
- Messages
- 4
I am hoping someone can help.
It seems like such an easy thing to do and I just can't find the answer anywhere.
So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes"
The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell to another location. I have set out as best I can an example below
<tbody>
</tbody>
It seems like such an easy thing to do and I just can't find the answer anywhere.
So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes"
The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell to another location. I have set out as best I can an example below
Date | Lead Name | Source | Sub Source | Sub Source Company | Application |
28/01/2019 | Example 1 | Self Generated | Example Source 1 | Example Sub Source 1 | Yes |
30/10/2019 | Example 2 | Self Generated | Example Source 2 | Example Sub Source 2 | No |
31/01/2019 | Example 3 | Self Generated | Example Source 3 | Example Sub Source 3 | Yes |
12/02/2019 | Example 4 | Self Generated | Example Source 4 | Example Sub Source 4 | No |
13/02/2019 | Example 5 | Self Generated | Example Source 5 | Example Sub Source 5 | Yes |
<tbody>
</tbody>