If cell blank copy next cell [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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.
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4131 users have said thank you to us this month

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
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