How to show all data with issues?

[Eylyn]

Can someone help me solve for b?

Policy	Sum Assured	Age
A	5000​	50​
B	x	40​
C	30000​	c
D	2000​	-12​
E	40000​	18​
F	70000​	25​
G	8000​	56​
H	h	48​

Please use macro to create additional two tab in Excel

1. <Clean Data> - to show all data without issues.
2. <Data with Issues> - to show all data with issues.

 

[Eylyn]

I don't know how to delete rows that the columns for sum assured and age are both numeric values >0.