Selelct cells for copy?

Set autofilter on table on;
Activate autofilter selection for column. Unselect Blanks and click <OK>;
Select all visible cells in filtered column;
Copy (or do whatever you wanted to do with those cells).