View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
s0200897 s0200897 is offline
external usenet poster
 
Posts: 1
Default Copy filtered table to Word

I've an excel file contains 1000 items (column A - E: #, Items, Part no.,
Qty, Date). After filter the table, I got 561 records out of 1000. Then I
will copy this filtered table to Word as Quotation Sheet.

But I found that one of the Quotation Sheet I did before shows there is ROW
1-1000 on table content. But the table on Word shows only 561 data. And I
can't find out where is the hidden data. When I copy this table to an excel
file. There is now 1000 data.

Does anyone know what cause this? Thank you very much.