Foxtable(狐表)用户栏目专家坐堂 → 咨询如何实现自动生产SN码


  共有378人关注过本帖平板打印复制链接

主题:咨询如何实现自动生产SN码

帅哥哟,离线,有人找我吗?
divil
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:童狐 帖子:235 积分:2054 威望:0 精华:0 注册:2012/9/23 10:42:00
咨询如何实现自动生产SN码  发帖心情 Post By:2024/3/29 18:31:00 [只看该作者]

版主,您好!
我用EXCEL做了自动申请SN码的公式,请问狐表可以做吗?附件已上传
盒号 :  MBA0522412  (手动输入信息)通过矩阵和设定公式,实现如下SN码(1-20个循环)
MBA05224121001-01
MBA05224121001-02
MBA05224121001-03
MBA05224121001-04
MBA05224121001-05
MBA05224121001-06
MBA05224121001-07
MBA05224121001-08
MBA05224121001-09
MBA05224121001-10
MBA05224121001-11
MBA05224121001-12
MBA05224121001-13
MBA05224121001-14
MBA05224121001-15
MBA05224121001-16
MBA05224121001-17
MBA05224121001-18
MBA05224121001-19
MBA05224121001-20
MBA05224121002-01
MBA05224121002-02
MBA05224121002-03
MBA05224121002-04
MBA05224121002-05
MBA05224121002-06
MBA05224121002-07
MBA05224121002-08
MBA05224121002-09
MBA05224121002-10
MBA05224121002-11
MBA05224121002-12
MBA05224121002-13
MBA05224121002-14
MBA05224121002-15
MBA05224121002-16
MBA05224121002-17
MBA05224121002-18
MBA05224121002-19
MBA05224121002-20
MBA05224121003-01
MBA05224121003-02
MBA05224121003-03
MBA05224121003-04
MBA05224121003-05
MBA05224121003-06
MBA05224121003-07
MBA05224121003-08
MBA05224121003-09
MBA05224121003-10
MBA05224121003-11
MBA05224121003-12
MBA05224121003-13
MBA05224121003-14
MBA05224121003-15
MBA05224121003-16
MBA05224121003-17
MBA05224121003-18
MBA05224121003-19
MBA05224121003-20
MBA05224121004-01
MBA05224121004-02
MBA05224121004-03
MBA05224121004-04
MBA05224121004-05
MBA05224121004-06
MBA05224121004-07
MBA05224121004-08
MBA05224121004-09
MBA05224121004-10
MBA05224121004-11
MBA05224121004-12
MBA05224121004-13
MBA05224121004-14
MBA05224121004-15
MBA05224121004-16
MBA05224121004-17
MBA05224121004-18
MBA05224121004-19
MBA05224121004-20
MBA05224121005-01
MBA05224121005-02
MBA05224121005-03
MBA05224121005-04
MBA05224121005-05
MBA05224121005-06
MBA05224121005-07
MBA05224121005-08
MBA05224121005-09
MBA05224121005-10
MBA05224121005-11
MBA05224121005-12
MBA05224121005-13
MBA05224121005-14
MBA05224121005-15
MBA05224121005-16
MBA05224121005-17
MBA05224121005-18
MBA05224121005-19
MBA05224121005-20
。。。。。。


 回到顶部