Is it possible to get Excel to check a column for a certain result ( invoice Needed ) and if that result exists add the PO number from Column A into the next cell in a different table, or am i asking too much of excel?
So in this example both 181/GB and 185/GB would need to added to the bottom of the new table
[TABLE="width: 207"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Job Done[/TD]
[TD]Already Invoiced[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]114/AB[/TD]
[TD]114/AB[/TD]
[/TR]
[TR]
[TD]181/GB[/TD]
[TD]Invoice Needed[/TD]
[/TR]
[TR]
[TD]185/GB[/TD]
[TD]Invoice Needed[/TD]
[/TR]
[TR]
[TD]125/SC[/TD]
[TD]125/SC[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
So in this example both 181/GB and 185/GB would need to added to the bottom of the new table
[TABLE="width: 207"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Job Done[/TD]
[TD]Already Invoiced[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]114/AB[/TD]
[TD]114/AB[/TD]
[/TR]
[TR]
[TD]181/GB[/TD]
[TD]Invoice Needed[/TD]
[/TR]
[TR]
[TD]185/GB[/TD]
[TD]Invoice Needed[/TD]
[/TR]
[TR]
[TD]125/SC[/TD]
[TD]125/SC[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]