ExcelBanter - Blank Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Blank Cells (https://www.excelbanter.com/excel-discussion-misc-queries/181634-blank-cells.html)

Sdbenn90

Blank Cells

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

Gary''s Student

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

All times are GMT +1. The time now is 11:13 AM.