Hi all,

I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2).

Now everything is ready to start the copying! So I select all the table (Double CTRL+A inside the table) then go into the "Go to special" dialog box and choose the "Visible cells only". Then I simply copy that selected filtered range of that table and paste it as follows, (image no. 3);

As it's clear, the right-side of the image shows the result of the copy-paste which of course is very odd! Why not all of the visible rows are pasted please?


Click image for larger version. 

Name:	image no. 1.PNG 
Views:	7 
Size:	25.5 KB 
ID:	2383


Click image for larger version. 

Name:	image no. 2.PNG 
Views:	5 
Size:	15.1 KB 
ID:	2384

Click image for larger version. 

Name:	image no. 3.PNG 
Views:	8 
Size:	23.9 KB 
ID:	2382