Blank Cells

  • Thread starter Thread starter Sdbenn90
  • Start date Start date
S

Sdbenn90

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel 2003 - Skip a cell 5
merging of cells 3
Unique cells 3
tiny discrepancies in fixed-point numbers 3
Count max consecutive cells 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Need macro to move to first blank cell in column 6

Back
Top