crazybuckeyeguy
New Member
- Joined
- Apr 15, 2017
- Messages
- 49
I know I am over thinking this. I have a spread sheet that we are adding a function for TR. the report we create is stupid and will list them as such:
<colgroup><col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;">
<col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;">
<col width="30" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1097;">
<col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;">
<col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;">
<col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2">
<col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;">
<col width="19" style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;">
<col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;">
<col width="19" style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;">
<col width="41" style="width: 31pt; mso-width-source: userset; mso-width-alt: 1499;">
<tbody>
</tbody>I need TR line not the multi_skill line. I obviously cant just delete the multi_skill line. I need this for some other agents. What am I doing wrong in the formula below?
For My_ROWS = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Range("A" & My_ROWS).Value = "" And Range("H" & My_ROWS).Value = "TR" Then _
or Range("H" & My_ROWS).Value = "TR" And Range("A" & My_ROWS + 1).Value = "TR" Then
Range("A" & My_ROWS).Copy Range("A" & My_ROWS + 1) and Rows(my_rows).delete
end if
Range("A" & My_ROWS - 1).Copy Range("A" & My_ROWS) and Rows(My_ROWS - 1).Delete
Next My_ROWS
BUCKNER, JENNIFER | Multi_Skill | 6:30 AM | 3:00 PM | Multi_Skill | 6:30 AM | 3:00 PM | |||||
TR | 6:30 AM | 3:00 PM | |||||||||
CAREFOOT, CHRISTINA | Multi_Skill | 6:30 AM | 3:00 PM | TR | 6:30 AM | 3:00 PM | |||||
Multi_Skill | 6:30 AM | 3:00 PM |
For My_ROWS = 1 To Range("A" & Rows.Count).End(xlUp).Row
If Range("A" & My_ROWS).Value = "" And Range("H" & My_ROWS).Value = "TR" Then _
or Range("H" & My_ROWS).Value = "TR" And Range("A" & My_ROWS + 1).Value = "TR" Then
Range("A" & My_ROWS).Copy Range("A" & My_ROWS + 1) and Rows(my_rows).delete
end if
Range("A" & My_ROWS - 1).Copy Range("A" & My_ROWS) and Rows(My_ROWS - 1).Delete
Next My_ROWS