如何通过销售数据生成销售单

娜美小姐

如果销售数据增加录入时候，销售单根据单号依次增加。谢谢谢谢

你是那块小饼干

试试VBA吧 函数难

娜美小姐

你是那块小饼干 发表于 2024-11-25 16:08
试试VBA吧 函数难

好的，谢谢你啦

你是那块小饼干

娜美小姐 发表于 2024-11-25 16:14
好的，谢谢你啦

1. =LET(T,SCAN(,A2:A12,LAMBDA(M,N,LOOKUP("座",A2:N))),_T,UNIQUE(T),DROP(REDUCE("",_T,LAMBDA(X,Y,VSTACK(X,VSTACK({"","","","","",""},HSTACK("","","","送货单","",""),HSTACK("客户:",XLOOKUP(Y,T,B2:B12),{"",""},"日期："&TEXT(TODAY(),"YYYY/MM/DD"),"送货时段: 早上"),HSTACK({"","","",""},"单据号",Y),{"序号","品名规格","单位","数量","单价（元）","金额（元）"},HSTACK(SEQUENCE(ROWS(FILTER(C2:G12,Y=T,""))),FILTER(C2:G12,Y=T,"")),HSTACK({"合计","","","",""},XLOOKUP(Y,T,H2:H12)),HSTACK("联系人：","满意 12345678901","","","",""))))),1))

复制代码

硬凑