in this photo we have three rows but there are blanks between them



in this photo there are no blanks because i autofiltered the blanks between
them.



i want to autofilter the first photo and copy a b c while autofiltered but
excel won't let me do that.

the real spread sheet is 8000 rows long with huge gaps between the filled
cells so i really can't do that unless i use the autofilter