HI
I have an Excel Sheet and I'm trying to Auto Generate Lab# in Column A(see the format is Screenshot) when Bulk Code is entered in Column B When I click Fill data Button
I know basic of VBA but I Can't Figure How I can Auto generate Lab#
Link to Screenshot Image
https://www.dropbox.com/s/x7m50021jun2958/Lab number.jpg?dl=0
I have an Excel Sheet and I'm trying to Auto Generate Lab# in Column A(see the format is Screenshot) when Bulk Code is entered in Column B When I click Fill data Button
I know basic of VBA but I Can't Figure How I can Auto generate Lab#
Link to Screenshot Image
https://www.dropbox.com/s/x7m50021jun2958/Lab number.jpg?dl=0