Autofilter in the column with the first character

  • Hello There,

    I'm looking a VBA code to do autfilter in a column by first character. I found some VBA codes but they didnt work on me.

    I have only numbers in A column. The are numbered from 1 to 30000 as random.

    According my codes if I just do seach "2" i can find it but i cant find wihch is numbered as 2533.

    I need a code that it will be filtering by the first character.

    Thank you for all help from now!

  • Ottomatic

    Changed the title of the thread from “Autofilter in thhe column with the first character” to “Autofilter in the column with the first character”.
  • The following code will identify any number in Column A beginning with 2 and paste it into column F


  • The following code will identify any number in Column A beginning with 2 and paste it into column F


    Thank you so much alansidman