· 正 · 文 · 来 · 啦 · 我们介绍了如何将表格复制到WORD中生成两栏打印,并使用域代码添加页码。今天介绍如何使用函数来查询打印。1、使用公式查询订单,分成两栏,每栏50条记录,每页100条记录![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_1_20210811094839410_wm)
![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_2_20210811094839691_wm)
![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_3_20210811094839801_wm)
![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_4_20210811094840458_wm) =INDEX(订单!$A$2:$E$859,(2*$K$2-2)*$L$2+ROW(A1),0)=INDEX(订单!$A$2:$E$859,(2*$K$2-1)*$L$2+ROW(A1),0)![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_5_20210811094840660_wm) ="第"&2*K2-1&"页/共"&CEILING(COUNTA(订单!A2:A859)/L2,1)&"页"="第"&2*K2&"页/共"&CEILING(COUNTA(订单!A2:A859)/L2,1)&"页"="第"&K2&"页/共"&CEILING(COUNTA(订单!A2:A859)/(2*L2),1)&"页"![](http://image109.360doc.com/DownloadImg/2021/08/1109/228163012_6_20210811094840863_wm) https://tldjs./iaORYsh7m6f
|