Hi!
I'm trying to make a macro that searches a date in cell A1 and a combination of two criteria in cell D1, then i need delete entire row, how can I do this?
Follow the example: A B C D
<tbody>
</tbody>
And the spreadsheet looks like this:
A B C D
<tbody>
</tbody>
I'm trying to make a macro that searches a date in cell A1 and a combination of two criteria in cell D1, then i need delete entire row, how can I do this?
Follow the example: A B C D
Date | Client | Count | Historic |
01/08/2013 | XXXXX | 1,019.00 | YYYYYY - 02/07/2013 |
01/08/2013 | XXXXX | 1,019.00 | YYYYYY - 29/07/2013 |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
05/08/2013 | XXXXX | 1,019.00 | WWWW |
01/08/2013 | XXXXX | 1,019.00 | YYYYYY - 31/07/2013 |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
<tbody>
</tbody>
And the spreadsheet looks like this:
A B C D
Date | Client | Count | Historic |
01/08/2013 | XXXXX | 1,019.00 | YYYYYY - 02/07/2013 |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
05/08/2013 | XXXXX | 1,019.00 | WWWW |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
01/08/2013 | XXXXX | 1,019.00 | WWWW |
<tbody>
</tbody>