查询并在另张SHEET上打印出来

leocaomf

<TABLE  cellSpacing=0 cellPadding=0 width=835 border=0 x:str>

<COLGROUP>

<COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3104" width=97>

<COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984" width=62>

<COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2112" width=66>

<COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4256" width=133>

<COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2016" width=63>

<COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1536" width=48>

<COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58>

<COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2112" width=66>

<COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2432" width=76>

<COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2560" width=80>

<COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1248" width=39>

<COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1504" width=47>





訂單號

客編

圖號

規格

數量

单重(g)

總重（kg)

离厂日

ETD HK

ETA JAPAN



距今日数



OJO3/06T0078-1







28,000

18.53

     518.94

5月29日

　

　

　

3

<TR  height=25>

OJO3/06T0100-1









18.53

  3,632.57

5月29日

　

　

　

<TD class=xl22  x:num x:fmla='=IF(H3-