- Object of the Macro
I want to:
- count the number of HSN digits in Column A,
- get them populated in Column C,
- filter the items with HSN less than 6 digits and
- get the dataset pasted at the cell H1.
2. The Code
Sub countcharactersincell()
Dim a As String
Dim b As Integer
Dim i As Integer
Dim j As Integer
Dim k As Integer
j = Cells.End(xlDown).Row
For i = 2 To j
a = Cells(i, 1)
b = Len(a)
Cells(i, 3) = b
Next i
Range("A1").AutoFilter Field:=3, Criteria1:="<6"
Range("a1:c" & Range("a1").End(xlDown).Row).SpecialCells(xlCellTypeVisible).Copy
Cells(1, 8).PasteSpecial
End Sub
3. Output
Funfact:
The same output could be achieved with a simple "Sorting" option of Excel.
But, I'm crazy about those "Mootai poochiyai kollum navina machine"
No comments:
Post a Comment