Excel 中同一位置怎么自动编号

1、打开VBA编辑器复制一下代码，打开VBA的方式WPS的是点开发工具

2、Private Sub Workbook_NewSheet(ByVal Sh As Object)

Dim sht

Dim a As Integer

a = 1

For Each sht In Worksheets

   sht.Range("b3") = "HB" & Format(Date, "yyyy-mm-dd") & "-" & a

   a = a + 1

   Next

End Sub