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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Reference (column a)[/TD]
[TD]Raise Order (column b)[/TD]
[/TR]
[TR]
[TD]828282[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]837489[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]354739[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838483[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]838482[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838481[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838488[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838480[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]838489[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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"?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Reference (column a)[/TD]
[TD](column b)[/TD]
[/TR]
[TR]
[TD]837489[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838483[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838480[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Reference (column a)[/TD]
[TD]Raise Order (column b)[/TD]
[/TR]
[TR]
[TD]828282[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]837489[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]354739[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838483[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]838482[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838481[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838488[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838480[/TD]
[TD]yes[/TD]
[/TR]
[TR]
[TD]838489[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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"?
[TABLE="width: 500"]
<tbody>[TR]
[TD]Reference (column a)[/TD]
[TD](column b)[/TD]
[/TR]
[TR]
[TD]837489[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838483[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]838480[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hope I've explained myself well.
Thanking you in advance