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
Configuration: Windows XP Firefox 3.0.11 Excel 2007
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 Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan |
Copy cell if blank excel 2003 Copy same cell in all files excel 2007 Copying songs from spotify Excel 07 if one cell is greater than another change color Excel command if cell equals some number Excel copy cell above Excel copying data between sheets if no data display nothing Excel how do i copy the first cell to the next blank cell down a column Excel when copying an empty cell display nothing How do i know if someone blocked me msn messenger How to add counter in excell if data entered in cell If data on cell 1 equals cell 5 , copy cell 6 to cell 8 If else has next file My computer stats but screen is blank Next column exel Test if blank screen is video card problem Trying to restore my pc by pushin f11 but it has a blank screen Windows 7 upgrade blank screen