mattwolves
New Member
- Joined
- Mar 9, 2018
- Messages
- 7
Hi folks, I'm hoping someone can help me with with my query.
I'm new to the site so please be gentle
I'm trying to write a spreadsheet for instructing someone to raise a purchase order if a cell is populated.
For example Sheet 1 would look like this below
<tbody>
</tbody>
With Sheet 2 looking something like below. Is there a way without using VBA to populate cells in column a with the reference number of column a from sheet 1 if column b (in sheet 1) has "yes"?
<tbody>
</tbody>
Hope I've explained myself well.
Thanking you in advance
I'm new to the site so please be gentle
I'm trying to write a spreadsheet for instructing someone to raise a purchase order if a cell is populated.
For example Sheet 1 would look like this below
Reference (column a) | Raise Order (column b) |
828282 | |
837489 | yes |
354739 | |
838483 | yes |
838482 | |
838481 | |
838488 | |
838480 | yes |
838489 |
<tbody>
</tbody>
With Sheet 2 looking something like below. Is there a way without using VBA to populate cells in column a with the reference number of column a from sheet 1 if column b (in sheet 1) has "yes"?
Reference (column a) | (column b) |
837489 | |
838483 | |
838480 | |
<tbody>
</tbody>
Hope I've explained myself well.
Thanking you in advance