Thread: Blank Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Blank Cells

1. make sure there is a header cell on the top of column B.
2. click on column B
3. Data Autofilter Custom is greater than 0
4. copy column B
5. click on A1 and paste
6. switch off AutoFilter
--
Gary''s Student - gsnu200776


"Sdbenn90" wrote:

I would like to copy Col B to Col A skipping the blanks or Zeros.

Example

Col A Col B
7853 7853
1597 1597
7874 0
7961 7874
7990
7994 7961
7990
7994