Split and Find or Left and Find?

[p9326]

I have a 2 worksheet 1 is for data base with 3 command buttons, 1 sheet for barcode scanner data transferring to excel with date and time stamp are included.

Could someone could help me to split or left and find functions to remove the date and time stamps on A2 and B2 Column when I click my consolidated button.

Here is the code in consolidated button.

Sub Sample()
    Dim ws As Worksheet
    Dim wsCon As Worksheet
    Dim lr As Long: lr = 2
    Dim wsLR As Long
   
    '~~> This is your Consolidated worksheet
    Set wsCon = ThisWorkbook.Sheets("Consolidated")
    wsCon.AutoFilterMode = False
   
    '~~> Clear the contents for input
    wsCon.Range("A2:C" & wsCon.Rows.Count).ClearContents
   
    '~~> Copy the data in to the Consolidated worksheet from other sheets
    For Each ws In ThisWorkbook.Worksheets
        If ws.Name <> wsCon.Name Then
            wsLR = ws.Range("A" & ws.Rows.Count).End(xlUp).Row
           
            ws.Range("A2:C" & wsLR).Copy wsCon.Range("A" & lr)
           
            lr = wsCon.Range("A" & wsCon.Rows.Count).End(xlUp).Row + 1
        End If
    Next ws
   
    With wsCon
        '~~> Remove duplicates
        .Range("A1:C" & lr).RemoveDuplicates Columns:=Array(1, 2, 3), Header:=xlYes
        '~~> Apply filter in row 1
        .Range("A1:C1").AutoFilter
    End With
End Sub

I attached the Picture for much

 

[p9326]

@Anthony47 sir, could you help me once again. Instead of making a user form, I will add new command button that shows only the items not been out in the system. , assuming the last green item is not being out when I press the new command button all the items gone and the only IN item will show so I can tell how many are still on my inventory, thank you in advance.

 

[Anthony47]

Sorry, but I shall not be able to work on your request auntil this evening (ie 11 hours from now).
If in the meantime you don't receive acknowledges please try to clarify the request, because you are using terms more related to what you do than what you show.

 

[Fluff]

Duplicate to: Auto filter? AutoRemove or AutoDelete.. Please Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.