eliminating blank cells

  • Thread starter Thread starter kherse sefid
  • Start date Start date
K

kherse sefid

I have two sheets in a workbook. Say sheet January and Summary. Sheet
January looks like this

DATE SN Amount TAX OVD CBS
12.01.2007 483 3464 1559 701 1184
13.01.2007 484 3907 1758 791 -627
14.01.2007 485 241 108 49 -75


17.01.2007 9/A12 1623 730 329 104

19.01.2007 11/A2 329 839 292 88


Now I want to gather these information in sheet "Summary" eliminating
the blank rows, so Summary looks like this:

DATE SN Amount TAX OVD CBS
12.01.2007 483 3464 1559 701 1184
13.01.2007 484 3907 1758 791 -627
14.01.2007 485 241 108 49 -75
17.01.2007 9/A12 1623 730 329 104
19.01.2007 11/A2 329 839 292 88


How can I do this please?
 
Look at Data>Filter>Autofilter, and filter on non-blanks

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top