View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeffm jeffm is offline
external usenet poster
 
Posts: 2
Default copy two columns without blanks in the first column

Hopefully someone out there can make this happen for me. I have data
coming from SQL into Excel that includes dates (in column "a", for
ex.), and then two additional data elements (columns "b" and "c" for
ex.) of data. I need to sort through column "b", and where a value
exists, copy that cell and the cell in column "a" to a second worksheet
into the same columnar format. The trick that is stumping me is I need
to skip the blanks in column "b". In other words, sheet2 needs to have
column "a" and 'b" without the blanks. The column range is from
a6:a110, b6:b110, c6:c110.

If I can get that part, then I can get add the next column to do the
same to another sheet. I would sure appreciate the help.

Jeff