if cell blank copy next cellClosed

Question

Hello,
I have a list in a certain column that contains blanks and I would like to consolidate that list to not include the blanks in another column.  I cant simply remove the blanks by using f5 because the list must update itself if changes are made to the original list.  The values in the cells are all numbers.  Is there any function that will copy a cell if it contains a value and search down for the next cell with a value to copy if blank?  Any help on this would be great!

Thanks

venkat1926 · Accepted Answer

try to filter non blanks and copy the filterd data 

In excek 2007 it is easy. click Home -sort and filter-click the arrow-remove tick from blanks.
copy it somewhere
comback ot the colulmn sortfilter-clear.

mubashir aziz · Answer

Hello,
I have a list in a certain column that contains blanks and I would like to consolidate that list to not include the blanks in another column. I cant simply remove the blanks by using f5 because the list must update itself if changes are made to the original list. The values in the cells are all numbers. Is there any function that will copy a cell if it contains a value and search down for the next cell with a value to copy if blank? Any help on this would be great!

Thanks

Yes auto filter command do the trick but it seems your sheet is linked with other sheet .... can you be more specific by giving some small example

If cell blank copy next cell

2 responses

Similar discussions

Subscribe To Our Newsletter!