Ask Your Question

Select only full cells on a column [closed]

asked 2012-03-08 16:34:54 +0200

Xpider gravatar image

updated 2015-10-26 21:58:28 +0200

Alex Kemp gravatar image

I have a difficult question, that i cant see how i may solve it. In a simple way, imagine that you have a column whit 32 lines, but not every lines on it are full.

The question is, how automaticaly (whit a funcion) i may select and copy only the lines whit data to another sheet?

Many thanks to you all that will try to help me on this.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-26 21:58:37.009081

3 Answers

Sort by » oldest newest most voted

answered 2013-03-14 05:25:44 +0200

ROSt52 gravatar image

Use autofilter and filter for Non Empty cells, then you select and copy the "full" cells.

Reading also Help: Only Copy Visible Cells is recommended

edit flag offensive delete link more



answered 2012-03-09 17:30:35 +0200

jofilho gravatar image

Automatically? Only through macro.

edit flag offensive delete link more


@Xpider -- are you waiting for actual macro code here? Are you still interested in an answer? Let us know..

qubit gravatar imagequbit ( 2013-03-13 04:51:55 +0200 )edit

answered 2013-03-14 22:21:52 +0200

m.a.riosv gravatar image

Using standard filter (Menu/Data/Filter/Standard), you can select a destination range for the filtered data.

image description

edit flag offensive delete link more

Question Tools



Asked: 2012-03-08 16:34:54 +0200

Seen: 6,593 times

Last updated: Mar 14 '13