First time here? Check out the FAQ!
asked 2012-03-08 16:34:54 +0200Xpider
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.
answered 2013-03-14 05:25:44 +0200ROSt52
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
answered 2012-03-09 17:30:35 +0200jofilho
Automatically? Only through macro.
answered 2013-03-14 22:21:52 +0200mariosv
Using standard filter (Menu/Data/Filter/Standard), you can select a destination range for the filtered data.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-08 16:34:54 +0200
Seen: 184 times
Last updated: Mar 14