Hallo guys, this is my first post. I just learn how easy using vba in my workplace.
I've a problem here. I've a sheet that contain sales report. But sometimes the data isn't filled as their should. I want to remove that 'unclean' data and put it in another workbook.
Example:
<tbody>
</tbody>
The criteria is:
1. If a Book then column a,b,c,d must be filled with either number or text
2. If a Pen then column a,b,c must be filled with either number or text
After i ran the VBA row 4 and 5 are not meet the criteria, so i want to delete the row and put the backup in another workbook ex:error.xls.
Thanks in advance.
I've a problem here. I've a sheet that contain sales report. But sometimes the data isn't filled as their should. I want to remove that 'unclean' data and put it in another workbook.
Example:
Sales Person | Product | A | B | C | D |
Jim | Book | 1 | 1 | A | A |
Dean | Pen | 1 | 1 | A | |
Dean | Pen | 1 | 1 | ||
Sarah | Book | 1 | 1 | A |
<tbody>
</tbody>
The criteria is:
1. If a Book then column a,b,c,d must be filled with either number or text
2. If a Pen then column a,b,c must be filled with either number or text
After i ran the VBA row 4 and 5 are not meet the criteria, so i want to delete the row and put the backup in another workbook ex:error.xls.
Thanks in advance.