Can I paste data missing out cells that are hidden ?
N NlCO Aug 22, 2005 #3 Yes, you can ! ! ! Try activating the autofilter in the desired column, and selecting the (NonBlanks) Then Select the entire column, Copy, and paste where you like, thats all ! ! Saludos NlCO
Yes, you can ! ! ! Try activating the autofilter in the desired column, and selecting the (NonBlanks) Then Select the entire column, Copy, and paste where you like, thats all ! ! Saludos NlCO
D Dave Peterson Aug 22, 2005 #4 It sounds like the OP want so paste into that filtered range (and skip the hidden rows)--just about the opposite of what you suggested.
It sounds like the OP want so paste into that filtered range (and skip the hidden rows)--just about the opposite of what you suggested.
