Trying to take a report that is copied from another program into excel and remove the unneeded data and format it into a usable format.
Code Currently using to remove Dates:
If Cell Like "Tuesday*" Or Cell Like "Monday*" Like Cell = "Wednesday*" Then
Cell.EntireRow.Delete
End If
It is not deleting anything. Does anyone know what I am missing?
Initial Format:
<colgroup><col span="17"></colgroup><tbody>
</tbody>Changed to:
<colgroup><col><col span="13"></colgroup><tbody>
</tbody>
Code Currently using to remove Dates:
If Cell Like "Tuesday*" Or Cell Like "Monday*" Like Cell = "Wednesday*" Then
Cell.EntireRow.Delete
End If
It is not deleting anything. Does anyone know what I am missing?
Initial Format:
Transaction Count | Scheduled In Queue | Actual In Queue | In Queue Variance | In Queue Variance % | Scheduled Out Of Queue | Actual Out Of Queue | Out Of Queue Variance | Out Queue Variance % | Total Scheduled | Total Variance | Total Adherence % | Non Scheduled / In Queue Hours | ||||
8284 | 1033.3 | 891.28 | 142.02 | 86.26% | 321.22 | 280.58 | 40.64 | 87.35% | 1354.52 | 182.66 | 86.51% | 11.12 | ||||
Agent, Troy | ||||||||||||||||
Schedule Date | Transaction Count | Scheduled In Queue | Actual In Queue | In Queue Variance | In Queue Variance % | Scheduled Out Of Queue | Actual Out Of Queue | Out Of Queue Variance | Out Queue Variance % | Total Scheduled | Total Variance | Total Adherence % | Non Scheduled / In Queue Hours | |||
Tuesday, 03 October 2017 | 1 | 0 | 0 | 0 | 0.00% | 2 | 2 | 0 | 100.00% | 2 | 0 | 100.00% | 0 | |||
Wednesday, 04 October 2017 | 1 | 2 | 0 | 2 | 0.00% | 0 | 0 | 0 | 0.00% | 2 | 2 | 0.00% | 0 | |||
Thursday, 05 October 2017 | 3 | 2 | 0 | 2 | 0.00% | 0 | 0 | 0 | 0.00% | 2 | 2 | 0.00% | 0 | |||
Friday, 06 October 2017 | 1 | 2 | 0 | 2 | 0.00% | 0 | 0 | 0 | 0.00% | 2 | 2 | 0.00% | 0 | |||
Monday, 09 October 2017 | 0 | 0 | 0 | 0 | 0.00% | 0 | 0 | 0 | 0.00% | 0 | 0 | 0.00% | 0 | |||
Subtotal: | 6 | 6 | 0 | 6 | 0.00% | 2 | 2 | 0 | 100.00% | 8 | 6 | 25.00% | 0 |
<colgroup><col span="17"></colgroup><tbody>
</tbody>
Agent Name | Transaction Count | Scheduled In Queue | Actual In Queue | In Queue Variance | In Queue Variance % | Scheduled Out Of Queue | Actual Out Of Queue | Out Of Queue Variance | Out Queue Variance % | Total Scheduled | Total Variance | Total Adherence % | Non Scheduled / In Queue Hours |
Agent, Troy | 6 | 6 | 0 | 6 | 0.00% | 2 | 2 | 0 | 100.00% | 8 | 6 | 25.00% | 0 |
<colgroup><col><col span="13"></colgroup><tbody>
</tbody>