Hello,
I have huge data in excel and i need to delete the particular data from that. Already got the excel script for deleting that "SE" from huge data. when i run that script, all the data was deleted in SE contained cell.
Need to modify script from my below request.
My request
1.To delete "SE" and after data in "SE" contained cell and after cell of "SE" contained cell.
Additional Requirement
2. Delete the "N°"
3. Delete 2nd row.
Please help me to do this things.
Regards,
Sampath.S
I have huge data in excel and i need to delete the particular data from that. Already got the excel script for deleting that "SE" from huge data. when i run that script, all the data was deleted in SE contained cell.
Need to modify script from my below request.
Code:
Sub RemoveDataAfterGrp()
Dim iCol, iRow As Integer
iCol = 1
iRow = 3
Do While Sheet1.Cells(iRow, iCol) <> ""
If VBA.InStr(1, Sheet1.Cells(iRow, iCol).Value, "Group", vbTextCompare) > 0 Then
Do
Sheet1.Cells(iRow, iCol).Value = ""
iRow = iRow + 1
Loop Until Sheet1.Cells(iRow, iCol).Value = ""
Else
iRow = iRow + 1
End If
If Sheet1.Cells(iRow, iCol) = "" Then
iCol = iCol + 1
iRow = 3
End If
Loop
End Sub
My request
1.To delete "SE" and after data in "SE" contained cell and after cell of "SE" contained cell.
Additional Requirement
2. Delete the "N°"
3. Delete 2nd row.
Please help me to do this things.
Regards,
Sampath.S
Attachments
Last edited by a moderator: