VBA for removing certain characters from the rows and creating a line chart out of it.

[Zee996]

Hello,

I am cleaning a large set of SAP data to create a line chart of it.

I have deleted unwanted rows from the VBA code -

Sub test()
With ActiveSheet
    .AutoFilterMode = False
    With Range("A1", Range("d" & Rows.Count).End(xlUp))
        .AutoFilter 1, "*sasdwk*"
        On Error Resume Next
        .Offset(1).SpecialCells(12).EntireRow.Delete
    End With
    .AutoFilterMode = False
End With
End Sub

#Taken help from this post - VBA Delete Entire Row if Contains Certain Text

Now, I want to clean the rest data in the rows that now look like this -

Column A

Wed Jan 25 10:20:58 IST 2023

atawork1 used=51 ctp=3300 1.55%

Wed Feb 1 10:47:00 IST 2023

atawork1 used=723 ctp=3300 21.91%

I want the output to look like this-

Date and Time Column A	Percentage Column B
Jan 25 10:20:58	1.55%
Feb 1 10:47:00	21.91%

And then create a line chart out of these two(Output) columns.

Is this something that can be achieved by VBA?