第1个回答 2022-03-15
方法1:在sheet2表A1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
b1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
c1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40)))
e1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
f1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
g1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+40)
i1=indirect("sheet1!a"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
j1=indirect("sheet1!b"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
k1=indirect("sheet1!c"&int((row()-1)/40)*120+if(mod(row(),40)=0,40,mod(row(),40))+80)
选中弟一行,公式一直下拉自动填充。
方法2:所有数据复制粘贴到word,分3栏,打印即可。本回答被提问者采纳